Hello all,
Just a quick one, I'm looking to try to plot a unique data point according to an x-axis or y-axis and then label it. A hypothetical example would be, I'd like to show a timeline of ticket sales with a marker showing when further COVID restrictions were announced, for example: 1 July-- COVID Restrictions announced. If the timeline was something like Perf Date, can anyone suggest an approach to try to achieve this?
Another example might be like "breakeven point" for ticket sales or something along those lines.
Grateful for any advice from any of you experts out there!
Jenna
Thanks very much all for your help, and will give that a try and come back with questions if I have any (very likely!) haha. Thanks again.
Chris Wallingford As predicted I'm having trouble-- thanks so much for your help:
So I tried the formula you suggested, and just put in a dummy value of 100, I then get this issue (which I've encountered many time before) where it will not display both values at once. So for instance, it toggles one value off whenever the other is activated. Could you explain in general why this toggling off happens? Any advice on this particular example? In this specific instance, I've got Order Date Days in Date as the x-axis category and I've got a simple order count by order date as the other value in the column chart.
Hi Jenna,
Based on the behavior you describe, it sounds like you also have a field in the Break By panel. If that's correct, column, bar, line and area charts only support rendering a single value when there is also a break by field in play.