Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I need some help with conditional. Let say i have a table that i got from script that looks like this
Number Value
5250 100,00
5450 150,00
6550 200,00
6670 200,00
If i create a CHART that uses number and value how to limit that chart to only show values that contain certain number or group of numbers. Example, how to only show 5250 (nothing else), or how to show all that start on 5%.
Thanks in advance.
Hi,
That's quite simple, for example if you create a chart using "Number" as a dimension and an expression like: sum({$<Number={5250}>} Value)
If you want to show all that start with 5:
sum({$<Number={'5*'}>} Value)
Regards,
Cesar
If you want to show only the values of number 5250 the easiest way is to add a listbox for the Number field and then select 5250 in that listbox. If you want the hardcode that value in the table you can try using Number as dimension and as expression sum({<Number={5250}>}Value).
Hi,
That's quite simple, for example if you create a chart using "Number" as a dimension and an expression like: sum({$<Number={5250}>} Value)
If you want to show all that start with 5:
sum({$<Number={'5*'}>} Value)
Regards,
Cesar