KPI to compare to last year

[tchovanec]

I have a straight table with a date cycle group as my only dimension. The cycle group use Year, month and date. I then have a few expressions and I was wondering if there was a way that for each expression I could maybe show an up or down arrow based on the previous year. So, if choose just 2013, I would want all the expressions to show 2013 data, but then have an up or down arrow showing if it was more or less than the previous year. The same would go if I showed a month or even a day. Any assistance would be greatful.

[v_iyyappan]

Hi,

Can you please provide the sample file to solve your requirement? because check the expression whether its correct or not thats y ask.

regards,

[tchovanec · Accepted solution]

I was able to figure it out by adding another expression. Here is an example of any expression I used and it worked perfectly.

IF(AVG(
{$<
LINE = {1}
,EVENT_TYPE = {50,65}
,ED_DISPOSISTION_TYPE =
,ED_DISPOSITION_C -= {113,1}

>}
IF(DT_PAT_DEP = ADDMONTHS(ISLAND_CAL.Date,-12),INTV_ED_LOS_MINS)
)

<

AVG(
{$<
LINE = {1}
,EVENT_TYPE = {50,65}
,ED_DISPOSISTION_TYPE =
,ED_DISPOSITION_C -= {113,1}
>}
IF(DT_PAT_DEP =ISLAND_CAL.Date,INTV_ED_LOS_MINS)
)

,'qmem://<bundled>/BuiltIn/arrow_n_r.png','qmem://<bundled>/BuiltIn/arrow_s_g.png')