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]

In the abve you can see result

As you see paranthesis is seen but value is not,

I add formula ina text objectş it gets value (in blue area)

[#3]

Hi,

May be it is not able to calculate sum properly, Please check your expression.

Also, attached here is a sample app for you to see how it works.

If you still face issue then attach you app.

..

Ashutosh

[QSense]

Hi ,

It's size is big nearly 2 gb I can not attach

[QSense]

Dimension  :

=Year(CalendarDate)&' ('&Aggr(Sum(CPN_BRD_PAX_KM)/Sum(AVA_SEAT_KM),Year(CalendarDate))&')'

Expression :

Sum(CPN_BRD_PAX_KM)/Sum(AVA_SEAT_KM)

[QSense]

Hi again,

My year field is CalendarDate

When I use it without year İn the formula ,It works but

CalendarDate format is dd.mm.yyyy So it works for each day but only ı want yearly avg

[#7]

Okay not an issue, you can pick correct year.

Use

=Year(date#(CalendarDate,'DD.MM.YYYY'))&' ('&Aggr(Sum(CPN_BRD_PAX_KM)/Sum(AVA_SEAT_KM),Year(date#(CalendarDate,'DD.MM.YYYY')))&')'

Just try it and let me know. It should work!! 

..

Ashutosh

[QSense]

Hi Ashutosh 

Unfortunately it didnt work

[#9]

Hi,

Can you please put below expression into text object and select a date, Do you get year value??

Year( date#( CalendarDate,'DD.MM.YYYY' ) )

..

Ashutosh

[#10]

Also, I see that in chart you are getting year value, how you are getting year there?

You can use the same field or formula and on basis of that can do aggregation.

[QSense]

Year( date#( CalendarDate,'DD.MM.YYYY' ) ) when ı put in into text object it gives error