how to display quaters expression value in bar chart

[kunkumnaveen]

Hello All,

i am trying to convert my straight table into bar chart,the problem is......i cant able to display quarters expression value...how to display then as well?.....

dimension:LOCATION

expression1:current score

exp2(current quarter) :FirstSortedValue(QUARTER,-ADATE)

exp3: previous score

exp4(previous quarter):FirstSortedValue(QUARTER,-ADATE,2)

exp2 and exp4 are missing

please fins the attachment .......

[kunkumnaveen]

Hi

shall  i share my qvw file?

[kaushiknsolanki]

Hi,

Yes please.

Regards,

Kaushik Solanki

[kunkumnaveen]

Hello.....

its on Sheet5............ after the coal sheet

[kunkumnaveen]

Hello

please find the  attached  qvw file  in the above reply

[kaushiknsolanki]

Hope this will solve your problem.

Regards,

Kaushik Solanki

[sunny_talwar]

This might be the other option available (or can be used in combination with Kaushik‌'s solution):

Axis on the bar shows Q3 and Q2.

[kunkumnaveen]

Hello,

i cant able to open the qvw....will u please brief me what i need to do

[kunkumnaveen]

Hi,

is this  reply for me or some one else?

[kaushiknsolanki · Accepted solution]

Opps Sorry Wrong paste..

Here is the what you are looking.

Use this as label for expression.

='Current Audit Score  (' & Aggr(FirstSortedValue(QUARTER,-ADATE), LOCATION) &')'

='Previous Audit Score(' & Aggr(FirstSortedValue(QUARTER,-ADATE,2), LOCATION) &')'

Regards,

Kaushik Solanki

[kunkumnaveen]

Hi

your bar chart look ok ,mine looks horrible .....how to achieve your one

please find the attachment