Imran Hasan
03/11/2025, 3:51 PMCeligo AI
03/11/2025, 3:51 PMAI generated answer (using internal Slack threads):To get distinct values in a saved search, you can use a summary search with a formula numeric. The Summary Type should be set to Count and the formula should be DISTINCT({field}). For example, if you want to get the distinct number of amounts, you can use DISTINCT({amount}). Here is an example of how you can use it:
code
Summary Type = Count
Formula = DISTINCT({amount})
This will count the distinct amounts in your saved search.
******
Disclaimer:
This response was generated by an artificial intelligence assistant based on previous conversations from multiple Slack channels, and may contain inaccuracies or mistakes.
******Celigo AI
03/11/2025, 3:51 PMSlack thread 1: here (available only if the original thread was posted in the last 90 days)
Similarity score: 0.8222664
Slack thread 2: here (available only if the original thread was posted in the last 90 days)
Similarity score: 0.804544091
Slack thread 3: here (available only if the original thread was posted in the last 90 days)
Similarity score: 0.80019
Celigo AI
03/11/2025, 3:51 PM