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.7K Product Ideas
- 1.7K Ideas Exchange
- 1.5K Connect
- 1.2K Connectors
- 292 Workbench
- 4 Cloud Amplifier
- 8 Federated
- 2.8K Transform
- 95 SQL DataFlows
- 602 Datasets
- 2.1K Magic ETL
- 3.7K Visualize
- 2.4K Charting
- 694 Beast Mode
- 43 App Studio
- 39 Variables
- 658 Automate
- 170 Apps
- 441 APIs & Domo Developer
- 42 Workflows
- 5 DomoAI
- 32 Predict
- 12 Jupyter Workspaces
- 20 R & Python Tiles
- 386 Distribute
- 111 Domo Everywhere
- 269 Scheduled Reports
- 6 Software Integrations
- 113 Manage
- 110 Governance & Security
- 8 Domo University
- 30 Product Releases
- Community Forums
- 39 Getting Started
- 29 Community Member Introductions
- 98 Community Announcements
- Domo Community Gallery
- 4.8K Archive