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
- 10.6K All Categories
- 1 APAC User Group
- 12 Welcome
- 36 Domo News
- 9.6K Using Domo
- 1.9K Dataflows
- 2.4K Card Building
- 2.2K Ideas Exchange
- 1.2K Connectors
- 339 Workbench
- 252 Domo Best Practices
- 11 Domo Certification
- 461 Domo Developer
- 47 Domo Everywhere
- 100 Apps
- 703 New to Domo
- 84 Dojo
- Domopalooza
- 1.1K ζ₯ζ¬ζ―ι¨
- 4 ιε ΄-ζ₯ζ¬ζ―ι¨γΈγγγγ
- 22 γη₯γγ
- 63 Kowaza
- 296 δ»²ιγ«ηΈθ«
- 649 γ²γγγε ±ζ