Filter Summary Number
I have multiple cards that show YOY New Business, YOY renewals and YOY overall. Currently the summary number only shows the total for all the years combined. I would like a way to filter the summary number to only show the most recent year or current active year. How can i acccomplish this?
Comments
-
Hi there!
One way this can be accomplished is by using the beast mode functionality.
You could create a beast mode titled for example: "Current Year New Business Summary". It might look something like this:
SUM
(Case when Year(`Date Column`) = Year(Current_date())
then `New Business Value Column`
else 0
end)
or if you had a way to determine the current active year you could do something like this:
SUM
(Case when Year(`Date Column`) = Year(Current_date())
or `Active Flag Column` = 'Active'
then `New Business Value Column`
else 0
end)
You could then use this beast mode column in your summary number, which would limit the summary value to only this year's total or current active year total.
Let me know if this is helpful or if I can provide any additional clarification.
**Say 'Thanks' by clicking the thumbs up in the post that helped you.
**Please mark the post that solves your problem as 'Accepted Solution'0
Categories
- All Categories
- 2K Product Ideas
- 2K Ideas Exchange
- 1.6K Connect
- 1.3K Connectors
- 310 Workbench
- 7 Cloud Amplifier
- 9 Federated
- 3K Transform
- 114 SQL DataFlows
- 654 Datasets
- 2.2K Magic ETL
- 4K Visualize
- 2.5K Charting
- 797 Beast Mode
- 78 App Studio
- 44 Variables
- 757 Automate
- 188 Apps
- 480 APIs & Domo Developer
- 72 Workflows
- 17 DomoAI
- 40 Predict
- 17 Jupyter Workspaces
- 23 R & Python Tiles
- 408 Distribute
- 119 Domo Everywhere
- 279 Scheduled Reports
- 10 Software Integrations
- 141 Manage
- 137 Governance & Security
- 8 Domo Community Gallery
- 47 Product Releases
- 12 Domo University
- 5.4K Community Forums
- 41 Getting Started
- 31 Community Member Introductions
- 114 Community Announcements
- 4.8K Archive