a chart issue

alexpanjhc — Thu, 20 Nov 2014 16:26:28 GMT

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

Re: a chart issue

Thu, 20 Nov 2014 20:01:17 GMT

Hi Alex,

Try this,

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

-Ed

alexpanjhc — Thu, 20 Nov 2014 20:49:28 GMT

Thanks Ed!