Set Analysis not displaying the value needed

[chibi]

I have a set analysis to show the value based on a ticket status, but instead of showing the value it's showing 0 

[Vegar · Accepted solution]

your expression will only work of you make sure that each row/bar/point only holds association to one tkt_status value.

It is probably a better approach to use set analysis. Try this expression:

=sum({<tkt_status={1}>}pay_or_cancel_amt)

[chibi]

Thank you so much! This works!