Announcements
cancel
Showing results for
Did you mean:
Contributor III

## List Box

Hi There,

I want to add a list box in my dashboard as below for only  "ACTUAL" values.

You can find attached data and dashboard files

Sum(Amount)

<0

0-50

50-100

100-250

250-500

500-1000

1000-5000

5000>

1 Solution

Accepted Solutions
MVP

Hi,

maybe one example could be:

hope this helps

regards

Marco

10 Replies
Champion

Hi,

you just need to do this on a list box:

=if(TYPE='ACTUAL', CLIENT)

attached below

MVP

Can you please clear your requirement, what is mean by below data.

Sum(Amount)

<0

0-50

50-100

100-250

250-500

500-1000

1000-5000

5000>

Contributor III
Author

Dear Youssef,

Actually i don't need List Box for Client.

I need to below list box.

Sum(Amount)

<0

0-50

50-100

100-250

250-500

500-1000

1000-5000

5000>

Contributor III
Author

Dear Anand,

This is Total Amount.

I want to, when i click to 0-50

Straight table must show only Actual sum amount 0 to 50 values. i.e.

 FILLO LOJISTIK ACTUAL 6 AYAYDIN GIYIM ACTUAL 6 SUNEL TICARET ACTUAL 6 KASTAS KAUCUK ACTUAL 16 ANIL BETON ACTUAL 23 PORLAND ACTUAL 27 GL EVENTS ACTUAL 31 TUBORG ACTUAL 38 GALERI ISTANBUL MOBILYA DEKORASYON ACTUAL 45
MVP

You have to use Class function here to create the buckets for this.

Champion

here is one method to do it, I'm sure there a lot of other approach better than this, but it works.

I just did the examples cases: <0 and >0

just finish the rest

find attached

MVP

Try to add this calculated dimension

=Dual(Replace(class( AMOUNT,50 ),'<= x <','to'), NUM(class( AMOUNT,50)) )

Creator

Using the Class function is the way to do this, as others have said.

An alternative if you don't like Class would be to use If or Case statements in your script to split the amounts into buckets, which you can then assign to a new field...

if(amount<50,bucket1,

if(amount<100,bucket2, etc.

Not as clean as using Class, but would do the job.

MVP

Hi,

maybe one example could be:

hope this helps

regards

Marco

Community Browser