select value from listbox

[#1]

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

[#2]

i tried if(wildmatch(Bucket,'On Time')Bucket)

But it won't work,display wrong result

[MayilVahanan]

Hi

Try like this in expression

=Sum({<Bucket = {'On Time'}>}Sales)

[#4]

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)

[#5]

if want to display airline?

[#6]

Use airline as dimension and the above expression for the data values. That way only airlines that were 'On Time' wil be displayed

[er_mohit]

Try this in calculated dimension side

aggr(only({<Bucket = {'On Time'}>} airline),airline)

check on suppress null value

[#8]

not useful for me

[#9]

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??

[Anonymous]

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.