Problem Statement
When using Domo to display % distributions over time (e.g., offer volume % by category), the platform recalculates percentages per time slice.
- This makes a value like 25% appear at different vertical positions in different periods if the total changes.
- The result is misleading visuals and makes trend analysis and cross-period comparisons less accurate.
Scenario: Offer Volume % by Calculator Name
Month | Total Offers | Category A Offers | Actual % for A |
|---|
Jan | 100 | 25 | 25% |
Feb | 10,000 | 2500 | 25% |
Mar | 300 | 75 | 25% |
Apr | 50,000 | 12,500 | 25% |
Expectation:
- In a line or bar chart, all four months for Category A should be plotted at the same horizontal Y-axis level (25%) since we are trying to look at the % distribution trend.
Reality in Domo’s Current Behaviour:
- Because each month’s % is recalculated independently for its bar or stack, the visual position for 25% shifts up or down depending on each month’s internal scaling.
- This makes it look like Category A is growing or shrinking when in fact it’s completely stable.
Benefits
- Clarity: Consistent, comparable percentages across periods.
- Efficiency: No need for Beast Modes or ETL pre-processing.
- Accessibility: Business users can achieve accurate visuals without technical help.
- Flexibility: Works for any chart type, not just stacked bars.
Desired Output
Current Output
Case Reference: 05908705
