Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello community
I am using a chart to show the percentage of the lost customers of a store in a time series.
I want to use the December as base month and observe the stores attrition rates.
Here is my challenge.
In my chart, I used only Period as my dimension.
in the expression I used set analysis
sum
({< Projects={'Lwd'},attr_stat={'3_True Attrition'}>}HH_FLAG) / $(vBaseHH)
where $vBaseHH=sum({ 1<Period={'201312'},Projects={'Lwd'}>}HH_FLAG)
When I plug this into expression, it will only show the percentage of December, other months are zero. I then realized that I can't do it this way.
How I can resolve this issue?
I tried: $vBaseHH=sum({ 1<Period={'201312'},Projects={'Lwd'}, perido=>}HH_FLAG) it just changed to each month's total not only december.
TIA
Hi Alex,
Try this,
$vBaseHH=sum({ 1<Period={'201312'},Projects={'Lwd'}>}Total HH_FLAG)
-Ed
Hi Alex,
Try this,
$vBaseHH=sum({ 1<Period={'201312'},Projects={'Lwd'}>}Total HH_FLAG)
-Ed
Thanks Ed!