Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello!
I have the following graph, and you can see the gray on top of each year. I want to get rid of that. The grey orders are as '-' classify. I tried using the following but it did not work out : If(Order Type <> '-', sum(amount))
I know I can deselect the option " Include Null Values", but if I do that, the rest of my dashboard will not make sense.
What can I do? Can I solve this with an if function?
Try Writing the below expression ,
=sum({<Order Type -={"-"}>}amount)
Try Writing the below expression ,
=sum({<Order Type -={"-"}>}amount)
You Rock!! thank u so much!