Quarter by Quarter comparison
Hi All,
I am trying to have analyzer display the percentage change from 3rd quarter of each year to 4th quarter of each year.
Currently my graph looks like this but I am unsure how to get the graph to display it
I have tried to format using a period over period chart but cannot figure out how to only show 3rd quarter to 4th quarter differences
Can someone help with formatting that?
If this helps, feel free to agree, accept or awesome it!
Best Answer
-
Period over Period charts are a bit limiting in their configuration, but you can remove the line by choosing Symbols Only in the Chart Properties → General → Line Style.
**Check out my Domo Tips & Tricks Videos
**Make sure to any users posts that helped you.
**Please mark as accepted the ones who solved your issue.0
Answers
-
Typically when I'm looking to do something a bit different between with PoP charts I'll create my own date dimension with custom offset information. I've done a write up on this here:
This method will allow you to filter for only Q4 and show the differences between the prior quarter.
**Was this post helpful? Click Agree or Like below**
**Did this solve your problem? Accept it as a solution!**0 -
Have you tried the Variance Bar Line chart in the Period over Period Charts? It shows the variance as a line for you. You can add data labels to make the values easier to see.
**Check out my Domo Tips & Tricks Videos
**Make sure to any users posts that helped you.
**Please mark as accepted the ones who solved your issue.0 -
@MarkSnodgrass Yeah, that was my initial thought. Maybe I am misunderstanding how to input the dates into the date field?
The comparison dates seem to be an issue.
If this helps, feel free to agree, accept or awesome it!
0 -
It seems as though when the BETWEEN date range is selected, it does act differently. This is what I am used to seeing.
I would try using the Previous → Last and choose last 6 years (which should get you back to 2018 that I saw in your between range) and choose the Graph By Quarter and Compare to 1 quarter. You can then use the main quick filters to exclude dates past 2022, which looked like what you are doing, and not do through the date range filter.
See if this configuration works for you.
**Check out my Domo Tips & Tricks Videos
**Make sure to any users posts that helped you.
**Please mark as accepted the ones who solved your issue.0 -
Ok, so now the numbers are correct but it looks horrible.
Is there a way to take out the just values (I want to keep the quarterly bar) from the bars and only keep the variance numbers? Can I delete those long looking lines?
Thanks for your help on this though.
If this helps, feel free to agree, accept or awesome it!
0 -
Period over Period charts are a bit limiting in their configuration, but you can remove the line by choosing Symbols Only in the Chart Properties → General → Line Style.
**Check out my Domo Tips & Tricks Videos
**Make sure to any users posts that helped you.
**Please mark as accepted the ones who solved your issue.0
Categories
- All Categories
- 1.8K Product Ideas
- 1.8K Ideas Exchange
- 1.5K Connect
- 1.2K Connectors
- 300 Workbench
- 6 Cloud Amplifier
- 8 Federated
- 2.9K Transform
- 100 SQL DataFlows
- 616 Datasets
- 2.2K Magic ETL
- 3.9K Visualize
- 2.5K Charting
- 738 Beast Mode
- 57 App Studio
- 40 Variables
- 685 Automate
- 176 Apps
- 452 APIs & Domo Developer
- 47 Workflows
- 10 DomoAI
- 36 Predict
- 15 Jupyter Workspaces
- 21 R & Python Tiles
- 394 Distribute
- 113 Domo Everywhere
- 275 Scheduled Reports
- 6 Software Integrations
- 124 Manage
- 121 Governance & Security
- 8 Domo Community Gallery
- 38 Product Releases
- 10 Domo University
- 5.4K Community Forums
- 40 Getting Started
- 30 Community Member Introductions
- 108 Community Announcements
- 4.8K Archive