Chart,dimension

[QSense]

Hi,

I have a problem. In chart graph,there is year dimension like 2009,2010.

For each year, I want to write avg the expresion value beyond the year dimension

how Can ı accomplish?

Best regards.

[QSense]

[QSense]

I want to get avg value of the Sum(CPN_BRD_PAX_KM)/Sum(AVA_SEAT_KM) expression and write to beyond for each year dimension

[#4]

What do you mean by beyond year dimension??

can you explain it a little?

..

Ashutosh

[QSense]

when you look at chart you see year dimension 2009,2010,2011

I want tol write dimension like this 2009 (Sum(CPN_BRD_PAX_KM)/Sum(AVA_SEAT_KM)) ,2010 (Sum(CPN_BRD_PAX_KM)/Sum(AVA_SEAT_KM)) vs..

for example let assume 2009 year's avg value 1000 I want show year dimension like this 2009 (1000)

in chart

[kaushiknsolanki]

Hi,

   You can try like this.

   Add calculated dimension. Use expression for dimension as

   =Year &'('& aggr(sum(Value1)/Sum(Value(2),Year) &')'

Regards,

Kaushik Solanki

[#7]

Hi,

Then yes you can write it as under your dimension

=dual(Year &'('& aggr(Sum(CPN_BRD_PAX_KM)/Sum(AVA_SEAT_KM),Year) &')', Year)

Just give it a try and let us know, if it works!!

..

Ashutosh

[QSense]

Unfotunately

it didnt work

[#9]

Hi,

Try this also, while it is same but still just give it a try.!!!

Year &'('& aggr((Sum(CPN_BRD_PAX_KM)/Sum(AVA_SEAT_KM)),Year) &')'

May be can you please share your app, or may be a sample app with your data. So, I can help you out on your app itself.!!!

..

Ashutosh

[#10]

Also, you will need to replace Year with your year field.