Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello All,
currently i am showing recent score and previous score of each parameter of each location, in a bar chart ,
but my client want me to show recent highest scores previous highest scores of each parameter irrespective of location fields..
what i mean is suppose if i select location = chanderia ,then i a bar chart i am showing all the latest scores and previous scores of each parameter for that particular location....
to achieve that i wrote each expression for each bar
expression for overall score current :
firstsortedvalue({<Category=,Decision=,name1=,ENSTEHDAT=,MaterialName= >} OVERALL_SCR, -ADATE)
so on i wrote all the expression for each parameter
now my requiremnt is on of top each bar i have to show highest recent score irrespective of location selected
i mean in my slide
for chanderia location: overall recent score is :71
so on top i need overall recent highest score among all location ....suppose highest score is 100 then i need 100 on top ..and this value should not change on any location selection.....
i think to achieve this i have to use a combo chart ,any how one value i am showing in bar so i think the highes values value i should show in dots
How about:
firstsortedvalue({<Category=,Decision=,name1=,ENSTEHDAT=,MaterialName= >} TOTAL OVERALL_SCR, -ADATE)
use Firstsortedvalue function
Vikas
May be something like this:
Max({<Category=,Decision=,name1=,ENSTEHDAT=,MaterialName= , LOCATION =>}Aggr(FirstSortedValue({<Category=,Decision=,name1=,ENSTEHDAT=,MaterialName= , LOCATION =>} OVERALL_SCR, -ADATE), YourChartDimensions))
first thing is i have not used any dimension in this chart ,all the recent and previous score of each parameters i got them from expression so each bar has each expression,
so what my doubt is do i need to write again each of your expression for each parameter to get recent highest score for each parameter
should i use combo chart ?
Are you intending to do this in another chart or the same chart? I am not sure why you need a combo chart, but if you don't have any dimensions, you can try this (for all your parameters)
Max({<Category=, Decision=, name1=, ENSTEHDAT=, MaterialName=, LOCATION =>} Aggr(FirstSortedValue({<Category=, Decision=, name1=, ENSTEHDAT=, MaterialName=, LOCATION =>} OVERALL_SCR, -ADATE), LOCATION))
UPDATE: When I say for all your parameters, I mean you will have to add one expression for each of your parameter
No what i mean is currently i am using just bar chart so it is possible to show two values on top of each bar
I assume you have a cross table like data structure in your data model, each parameter in one field.
Maybe consider transforming this table to a straight table using a CROSSTABLE (Parameter, Value) LOAD prefix, then use the new Parameter field as dimension in your chart.
This might simplify your charts to great extent, you probably only need one expression (and one for the max total value).
May be use text on axis option? I don't really know how this is going to play out since you don't have a dimension. But if you can share a sample of your application, we can play around with it.