Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
suppose i have 4 values in listbox named as bucket having values as on Time,15-30,30-60,>60
i want to create a chart only for on time,what will be the expression in calculated dimension
i tried if(wildmatch(Bucket,'On Time')Bucket)
But it won't work,display wrong result
Hi
Try like this in expression
=Sum({<Bucket = {'On Time'}>}Sales)
You don't have to use a calculated dimension here: define the scope of the analysis in the expression like this:
=Sum({<Bucket = {'On Time'}>} Value)
if want to display airline?
Use airline as dimension and the above expression for the data values. That way only airlines that were 'On Time' wil be displayed
Try this in calculated dimension side
aggr(only({<Bucket = {'On Time'}>} airline),airline)
check on suppress null value
not useful for me
i have already created chart
dimension:
expression:
Expression
=Count( {<FlightType={'Departure'},FlightDestType={'International','Domestic'} >} IF(WildMatch(NatureCode,'*1*','*8*','*5*'), FLNO))
if i selected indigo flight it display
the new requirement is ,I have to create a new chart for only On Time
for this i used the following
Expression
=(Count( {<Bucket={'On Time'},FlightType={'Departure'},FlightDestType={'Domestic'} >} IF(WildMatch(NatureCode,'*1*','*8*','*5*'), FLNO)))
dimension
=Aggr(Only({<Bucket_new={'On Time'}>}AirlineName),AirlineName)
but selction of indigo and other flight it display wrong result as compare to other
like in indigo
it show 100% instead of 91%
Any sugg??
Use
=Count({<Bucket = {'On Time'}>} Airlines)
This will give you the count of the number times an airlines was on time.
Plot this against the Airlines name.