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 calculated for the entire period, not per date.For example, for the month of 04/2023 the number of "No" users was 171 and the number of "Not Decided Yet" users was 272. I want the chart to show 39% for "No" and 61% for "Not Decided Yet". Instead, the chart shows 10% for "No" and 8% for "Not Decided Yet".&n...

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" an...

Create a % Contribution Over Time Calculation | Help and How-To

MoreDiscussions

Create a % Contribution Over Time Calculation | Help and How-To | Sisense Community