How to show YTD data in Tabular format?
I want to display YTD data in a tabular format. How can I achieve this using BM. I have a dataset with columns like 'Date' and 'Metric'
The attached screenshot is a general idea of how I'm trying to organize the data.
Thank you!
Best Answer
-
@SayyedHussain If you want to only include months to date you can add a beast mode filter like the one below:
case when MONTH(`Date`) <= MONTH(CURRENT_DATE()) then 'Include' else 'Exclude' end
2
Answers
-
@SayyedHussain You can accomplish this with a pivot table card with
MONTHNAME(`Date`)
andYEAR(`Date`)
as your columns and rows, respectively, and `Metric` as your values. You can also useMONTH(`Date`)
to sort your months chronologically0 -
@Michelle Thank you for your response. I used a Pivot table and utilized the MonthName and Year functions.
However, it is currently showing data for all months of both the current and previous years. The goal is to show data for the current year from starting of the year to current month as well as data for the previous year. This will allow for a comprehensive view of the YTD data.0 -
@SayyedHussain If you want to only include months to date you can add a beast mode filter like the one below:
case when MONTH(`Date`) <= MONTH(CURRENT_DATE()) then 'Include' else 'Exclude' end
2 -
@MichelleH It's working as expected now. Thank you for your help!! 😀
1
Categories
- All Categories
- 1.7K Product Ideas
- 1.7K Ideas Exchange
- 1.5K Connect
- 1.2K Connectors
- 294 Workbench
- 6 Cloud Amplifier
- 8 Federated
- 2.8K Transform
- 97 SQL DataFlows
- 607 Datasets
- 2.1K Magic ETL
- 3.8K Visualize
- 2.4K Charting
- 707 Beast Mode
- 49 App Studio
- 39 Variables
- 667 Automate
- 170 Apps
- 446 APIs & Domo Developer
- 44 Workflows
- 7 DomoAI
- 33 Predict
- 13 Jupyter Workspaces
- 20 R & Python Tiles
- 391 Distribute
- 111 Domo Everywhere
- 274 Scheduled Reports
- 6 Software Integrations
- 115 Manage
- 112 Governance & Security
- Domo Community Gallery
- 31 Product Releases
- 9 Domo University
- 5.3K Community Forums
- 40 Getting Started
- 30 Community Member Introductions
- 103 Community Announcements
- 4.8K Archive