Hello !
I searched for a solution for this problem for some time now but without succes.
So, what i have is a dimension and a few measures based on percentage i took from the excel that was given to me, i then use them in a stacked bar chart :
![currentChart.png](/legacyfs/online/179525_currentChart.png)
And what i want is add a 'total' bar with the sum of the measures for all the years like so (on excel):
![targetChart.png](/legacyfs/online/179526_targetChart.png)
Is there a way to do that?
The data i have roughly look like that :
client | Year2017 | Year2016 | Year2015 | Year2014 |
---|
1 | waiting | | | |
2 | | ok | | waiting |
3 | | gave up | | |
4 | | | | not ok |
5 | | | ok | |
my dimension is declared like so :
if(
[Year2014]='' and [Year2015]='' and [Year2016]='',
'Cohorte2017',
if(
[Year2014]='' and [Year2015]='',
'Cohorte2016',
if(
[Year2014]='',
'Cohorte2015',
'Cohorte2014'
)
)
)
and here is an example of one of the measures that i then transform into %:
Sum(
if(
[Year2017]='' and [Year2016]='' and [Year2015]='' and [Year2014]='',
0,
if(
[Year2017]='',
if(
[Year2016]='',
if(
[Year2015]='',
if([Year2014]='waiting',1,0),
if([Year2015]='waiting',1,0)
),
if([Year2016]='waiting',1,0)
),
if([Year2017]='waiting',1,0)
)
)
)
thanks in advance !