a chart issue

[alexpanjhc]

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

[#2 · Accepted solution]

Hi Alex,

Try this,

$vBaseHH=sum({ 1<Period={'201312'},Projects={'Lwd'}>}Total HH_FLAG)

-Ed

[alexpanjhc]

Thanks Ed!