Card Type - POP Table
Enable YOY (or other period-over-period calculations) as a table. Example below.
This can be done in bar and line charts, for a table one must use a series of beast modes. This also then means you can't use the date filters buttons effectively.
Example:
Comments
-
You can use the Flex Table card to do this. You can adjust what is displayed in each column so that you don't see a bar or line graph, but the actual numbers.
https://domohelp.domo.com/hc/en-us/articles/360043429073-Flex-Table
**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.2 -
@MarkSnodgrass - Apologies for the really late response, and thank you for the reply.
How are you getting % Change YOY from that? I only have options to calculate % change against either the first or the penultimate value, neither of which are "last year". Do you have to aggregate the dataset some weird way? If so, then how do you use the data filters to toggle between YTD / MTD / Last Month etc?
Here's another example, this one uses sales channel instead of month as the group:
The Flex Table option in the POP section would work if it allowed grouping, but it doesn't.
The Flex Table in the Tables section would work if it allowed POP comparisons, but it doesn't.
I've asked Domo support, still no solution. What am I missing here?
Thank you!
0 -
I agree 100%, I work with a lot of financial data and I need to calculate the variations PoP on a beast mode or on a ETL process, but since I use Fiscal Year sometimes gets messy. And I don't want to see the graph as in a Flex Table :(
1 -
Thanks @LiliRestrepo - agreed!
I use the beast mode method too but it doesn't work with the Date Filters (the drop down used to select Month to Date or This Year etc.)
I'm really surprised this is not simpler to do in Domo!
1
Categories
- All Categories
- 1.8K Product Ideas
- 1.8K Ideas Exchange
- 1.5K Connect
- 1.2K Connectors
- 296 Workbench
- 6 Cloud Amplifier
- 8 Federated
- 2.9K Transform
- 100 SQL DataFlows
- 614 Datasets
- 2.2K Magic ETL
- 3.8K Visualize
- 2.5K Charting
- 729 Beast Mode
- 53 App Studio
- 40 Variables
- 677 Automate
- 173 Apps
- 451 APIs & Domo Developer
- 45 Workflows
- 8 DomoAI
- 34 Predict
- 14 Jupyter Workspaces
- 20 R & Python Tiles
- 394 Distribute
- 113 Domo Everywhere
- 275 Scheduled Reports
- 6 Software Integrations
- 121 Manage
- 118 Governance & Security
- Domo Community Gallery
- 32 Product Releases
- 10 Domo University
- 5.4K Community Forums
- 40 Getting Started
- 30 Community Member Introductions
- 108 Community Announcements
- 4.8K Archive