Hi everyone,
I'm trying to make a BarChart with two containers: Absolute and Percentage.
As the name says, the Absolute one gives the Absolute Number per Score, and the Percentage gives the Percentage Numbers per Score.
Currently, when i'm doing the Percentage for the Score, my values for each Bar does not add up to 100% (currently, 106%).
- Dimension in the BarChart: [Score]
- Absolute Set Analysis:
num(Sum( {<[Year]={"$(=Max(Date(Year, 'YYYY')))"},
[Field]={">0"}, [Score1]={"=Len(Trim([Score1]))>0"}>} [Customer Counter]), '#,##0')
num(Sum( {<[Year]={"$(=Max(Date(Year, 'YYYY')))"},
[Field]={">0"}, [Score1]={"=Len(Trim([Score1]))>0"}>} [Customer Counter]), '#,##0')
/
num(Sum( TOTAL {<[Year]={"$(=Max(Date(Year, 'YYYY')))"},
[Field]={">0"}, [Score1]={"=Len(Trim([Score1]))>0"}>} [Customer Counter]), '#,##0')
Can someone help me to understand where i'm messing up the 100%?
I've tried to encapsulate the Percentage calculation with Avg(Aggr(...., [Score])), but it does not give me 100%.
Thank you for the help!