Forum Discussion
Solved
Cancelled vs Active in Column Chart
Hi all, I have a table, Gifts, with a Status field that can be either Cancelled or Active. The original setup is shown by the field Type = Recurring Gift, and the payments to the gift are of type...
Hello! You can add a column with an IF statement as: if status = active, 1, if status = cancelled, -1. THen use this column as the value in the Y-axis. Then you can use status as a legend to seperate them etc. Active will only have + values and cancelled will only have - values
Thank you sgetgood
👍