Can dashboard tiles show the numeric result from a...
# ask-stanley-ai
t
Can dashboard tiles show the numeric result from a saved search that is using different filters in each tile
c
AI generated answer (using internal Slack threads):
Yes, dashboard tiles can show the numeric result from a saved search that is using different filters in each tile. However, the type of tile you use will determine what kind of data is displayed. For instance, if you want to show the total value, you should use a scorecard type tile. The scorecard type sums up the first numeric column of the search. On the other hand, the reminder type counts the search results. If you only have reminder and static types, you might want to try using a custom search portlet. In the search, use the summary function for count or sum to show the count and total sales. You can also show the results graphically. When building a saved search and you'd like to filter by the amount of a transaction, one workaround is to add a Formula (text) criteria. Use a nominal amount for the default search, then add Formula (text) as an Available filter. Another solution might be to use a Dashboard 'Search Form' which works from the criteria from the Results columns instead of in Criteria. If you want to make a formula in a saved search to show the difference between two numeric fields (x-y), you can use a numeric formula field,
{x}-{y}
. However, if you want the difference between two summary fields, this might not be possible. ****** Disclaimer: This response was generated by an artificial intelligence assistant based on previous conversations from multiple Slack channels, and may contain inaccuracies or mistakes. ******
Slack thread 1: here (available only if the original thread was posted in the last 90 days)
Similarity score: 0.850965559
Slack thread 2: here (available only if the original thread was posted in the last 90 days)
Similarity score: 0.826445639
Slack thread 3: here (available only if the original thread was posted in the last 90 days)
Similarity score: 0.818628967
Please provide your feedback on this answer.