Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I currently have only two fields, TotalDataPoints and BadDataPoint. I want my bar chart to have a dimension of integers from 1 to TotalDataPoints (=ValueLoop(1,TotalDataPoints,1)). My only expression is =1 so that they are all equal length bars. I have this done so far (See pic below). I would like to change the color of bars that have a dimension value equal to BadDataPoint. For example, if I have BadDataPoints of 10,25, and 40, then the corresponding bars would be colored red. I would really appreciate any help with this.
Use condition on background color of expression.(which is under + sign of expression)
Do you have any criteria or flag column that would determine BadDataPoints??
For suppose flag=1 is for BadDataPoints
put a condition like below in background color
= if(flag=1,red(),green())
I am now getting closer to my desired result. Unfortunately, there are twice as many bars in the chart as I need. I believe this is because I am using two dimensions. The only expression is still =1. Any one know how to fix this?