Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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 .......
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
Hi,
Both Expressions are not shown because they are text.
Because the Current Quarter and Previous quarter will remain same for all locations, you can just display them on chart using the "Show Title in Chart" option under General Tab.
Regards,
Kaushik Solanki
Hello,
what exactly do i need to do..?
as u said i tried by writing this expression in "Show Title in Chart".... ....
FirstSortedValue(QUARTER,-ADATE)
but no change ....that what u mean
Hi,
You wont get the Quarter values in Bar, instead I am saying you to show the Quarters as text, instead of Bar.
The function which you used should have gave you current quarter.
Regards,
Kaushik Solanki
HI,
Sorry for annoying you ......so u mean i should use text box to display those dynamic quarters...but in case if each location quarter varies then?...currently i am using sample data
Hi,
Can you paste sample Data, I will show you what you can do.
Regards,
Kaushik Solanki
How exactly do you imagine to see this Quarter data on a bar chart?
Hello sunny,
to be honest with you i actually dont know how to display them..but only the thing is as it is crystal clear when ur looking at the straight table will it be possible that clear by using bar chart ...what i mean like in straight table
current score and current quarter and previous score and previous quarter ........so the user should see score and its respective quarter
HI ..
as the data is in remote area its not letting me to copy
please find the attachment (data slide)
Does current score corresponds to current quarter and previous score corresponds to previous quarter? If it does, then may be text on axis can be used where you can show that current score belongs to current quarter underneath the bar?