Solved
Create a % Contribution Over Time Calculation
I am trying to create a stacked bar chart view that shows the % of each category, for each date, over time. However, when I try to use the contribution function, the % values returned are calculate...
hey mmalhame ,
the contribution function provide the Contribution for the Date Column while the need is to show the Contribution, i.e. percentages out of total, for each category for the same period.
A quick solution which can provide this is to modify the widget formula.
the new formula: COUNT([case_id]) / (COUNT([case_id]),all(Dimension_name))Formula Explanation:
- All function - ignore the scope of the Dimension.
- the dimension is the column name which return the value of "No" and "Not Decided Yet"
See example - using simple Count [# of OrderQty]
Using the formula include ALL Function: [# of OrderQty]/ ([# of OrderQty],all([Region]))
the Contribution display for each chartBest Regards
