Week to date conversion
Hi Guys,
i have a requirement to display weekly revenue data in a group of quarter and year like attached.
How can i make it grouped with taking 2dimension in X-axis.
Best Regards
Bikash
Comments
-
Hi Bikash
I can't think of a way to nest multiple time labels on an X Axis. Here's one thing you can try, though.
Create a Quarter beast mode and use it as the series in order to call attention to the quarters in addition to the weeks on the label
Aaron
MajorDomo @ Merit Medical
**Say "Thanks" by clicking the heart in the post that helped you.
**Please mark the post that solves your problem by clicking on "Accept as Solution"0 -
You could also do a nested view. I know my data here is not matching your specific case, but you could have the nested group be the quarters (this way you could see the quarter total) with the inner bars being the total for each week. Then the summary number would be providing the total for the year.
“There is a superhero in all of us, we just need the courage to put on the cape.” -Superman0 -
Thanks for your reply.
But just curious how can i create a nested view.
Thanks
Bikash
0 -
Hmm.... It is not behaving the way that I expected it to. However, a Nested Bar is a chart type that you can select from the Vertical Bar charts. Here is a look at what I just made. However, I was hoping that each quarter would only contain data for the weeks that were applicable.
“There is a superhero in all of us, we just need the courage to put on the cape.” -Superman0 -
You could also create a "Running Total Line" graph.
Otherwise, my suggestion would be to start with a view of the information by quarter and create a drill path that would then give the details by week.
“There is a superhero in all of us, we just need the courage to put on the cape.” -Superman0
Categories
- All Categories
- 1.2K Product Ideas
- 1.2K Ideas Exchange
- 1.3K Connect
- 1.1K Connectors
- 273 Workbench
- 2 Cloud Amplifier
- 3 Federated
- 2.7K Transform
- 78 SQL DataFlows
- 525 Datasets
- 2.1K Magic ETL
- 2.9K Visualize
- 2.2K Charting
- 435 Beast Mode
- 22 Variables
- 513 Automate
- 115 Apps
- 390 APIs & Domo Developer
- 8 Workflows
- 26 Predict
- 10 Jupyter Workspaces
- 16 R & Python Tiles
- 332 Distribute
- 77 Domo Everywhere
- 255 Scheduled Reports
- 66 Manage
- 66 Governance & Security
- 1 Product Release Questions
- Community Forums
- 40 Getting Started
- 26 Community Member Introductions
- 68 Community Announcements
- 4.8K Archive