Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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>
Please help me
Hi,
you just need to do this on a list box:
=if(TYPE='ACTUAL', CLIENT)
attached below
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>
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>
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 |
You have to use Class function here to create the buckets for this.
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
Try to add this calculated dimension
=Dual(Replace(class( AMOUNT,50 ),'<= x <','to'), NUM(class( AMOUNT,50)) )
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.
Hi,
maybe one example could be:
hope this helps
regards
Marco