Is there a way to show averages for last day of month

I have data (cumulative totals and averages) for a dataset by day for various products...
I'd like to create a bar chart that shows the collective sum of the cumulative totals and collective average of the averages for the last day of each month...
Can anyone advise on how to do this?
Best Answer
-
If you are only want to show the data for the rows that contain the last day of each month you could create a beast mode that would evaluate this for you:
CASE WHEN datefield = LAST_DAY(datefield) THEN 'Last Day of the Month' ELSE 'Some other day' END
You can then add this to the filtering section of the card and filter to "Last Day of the Month"
Let me know if you are trying to do something else.
**Check out my Domo Tips & Tricks Videos
**Make sure toany users posts that helped you.
**Please mark as accepted the ones who solved your issue.0
Answers
-
If you are only want to show the data for the rows that contain the last day of each month you could create a beast mode that would evaluate this for you:
CASE WHEN datefield = LAST_DAY(datefield) THEN 'Last Day of the Month' ELSE 'Some other day' END
You can then add this to the filtering section of the card and filter to "Last Day of the Month"
Let me know if you are trying to do something else.
**Check out my Domo Tips & Tricks Videos
**Make sure toany users posts that helped you.
**Please mark as accepted the ones who solved your issue.0
Categories
- All Categories
- Product Ideas
- 2.1K Ideas Exchange
- Connect
- 1.3K Connectors
- 309 Workbench
- 7 Cloud Amplifier
- 10 Federated
- Transform
- 664 Datasets
- 119 SQL DataFlows
- 2.3K Magic ETL
- 823 Beast Mode
- Visualize
- 2.6K Charting
- 86 App Studio
- 46 Variables
- Automate
- 194 Apps
- 484 APIs & Domo Developer
- 90 Workflows
- 24 Code Engine
- AI and Machine Learning
- 23 AI Chat
- 4 AI Projects and Models
- 18 Jupyter Workspaces
- Distribute
- 119 Domo Everywhere
- 283 Scheduled Reports
- 11 Software Integrations
- Manage
- 143 Governance & Security
- 11 Domo Community Gallery
- 49 Product Releases
- 13 Domo University
- Community Forums
- 41 Getting Started
- 31 Community Member Introductions
- 116 Community Announcements
- 5K Archive