Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello
I have a table with the following field. Both the fields are numeric.
Sessionid | Paid Registrations by Attendee
12345 100
12345 200
12345 300
12345 100
22345 50
22345 20
22345 30
22345 100
22345 0
22345 0
22345 0
22345 0
I have a bar chart with session id as a dimension and Sum([Paid Registrations by Attendee]) as a measure. I am only looking to display Sum([Paid Registrations by Attendee]) if the value is greater than 0 or not equal to 0.
Is there a way to do this?
Thanks in advance.
Sheetal.
So, you do you want to only show the expression is greater than 0 or do you also want to show it when it is less than 0?
Set the Limitation to exact value and select ">0" under dimension in edit mode.
Hi Sunny
I am looking to display only if the value is greater than zero but I believe not equal to zero will also work.
Basically I want to exclude all sessions where we have received zero dollars from the bar graph , so display Sum([Paid Registrations by Attendee]) on the Y-axis only if Sum([Paid Registrations by Attendee]) > 0. Any idea how I can do this? Thanks for your help.
Did you already try to uncheck 'Include Zero values' under Add-Ons -> Data handling? If not, give that a shot
You can do this two ways.
1. Chart setting:
2. Set Analysis
If you need the aggregate:
Sum({<Paid_Registrations_by_Attendee={">0"}>} Paid_Registrations_by_Attendee)
If just the field value:
Sum({<Sessionid={"=Sum(Paid_Registrations_by_Attendee)>0"}>} Paid_Registrations_by_Attendee)
That resolved it for me...
Sum({<Sessionid={'=Sum([Paid Registrations by Attendee])>0'}>} [Paid Registrations by Attendee])
Thank you. That worked.