Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello, a quick bullet chart question :
I have 2 fields : [Scheduled Month] and [Actual Month], defining the time where certain events were planned and executed.
Every row has a [Scheduled Month], but only completed events have an [Actual Month]. I would like to show on a bullet chart the monthly evolution of scheduled reports during that month compared to executed events during that month.
I can easily enough define [Scheduled Month] as the dimension, and count([Scheduled Month]) as the target. For the executed ones I have a problem, I do not know how to make the graph understand that both fields are the 'same'. I can put something like Count(If([Actual Month]=[Scheduled Month],[Actual Month])), but this is an approximation, as certain events were processed in a different month then the scheduled one, and they are simply lost.
So I guess my question is, is there a way to plot count([Actual Month]) on the same dimension as count([Scheduled Month]) ? Or any common workarounds, I'm sure this is a common use-case.
Thanks in advance,
LJ
i think you can use stacked bar chart it will solve your issue.