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
- 1.8K Product Ideas
- 1.8K Ideas Exchange
- 1.6K Connect
- 1.2K Connectors
- 302 Workbench
- 6 Cloud Amplifier
- 9 Federated
- 2.9K Transform
- 104 SQL DataFlows
- 633 Datasets
- 2.2K Magic ETL
- 3.9K Visualize
- 2.5K Charting
- 760 Beast Mode
- 62 App Studio
- 42 Variables
- 699 Automate
- 181 Apps
- 457 APIs & Domo Developer
- 51 Workflows
- 10 DomoAI
- 38 Predict
- 16 Jupyter Workspaces
- 22 R & Python Tiles
- 401 Distribute
- 116 Domo Everywhere
- 277 Scheduled Reports
- 8 Software Integrations
- 130 Manage
- 127 Governance & Security
- 8 Domo Community Gallery
- 38 Product Releases
- 12 Domo University
- 5.4K Community Forums
- 40 Getting Started
- 30 Community Member Introductions
- 111 Community Announcements
- 4.8K Archive