1 of 1 people found this helpful
Hi Praseed. Can you be a little clearer on how you'd like to see this information depicted? It seems easy enough to create a series of graphs to show each metric's Actual vs Target and compare this performance against prior years:
If you're needing to show Actual vs Target vs Previous Year (Actual ?) on the same line, though, we might be looking at a different type of display altogether. I believe a dual axis bullet graph is possible, but it might be terribly confusing.
Thanks for responding.
Your idea seems fine. I agree that dual axis bullet graph will be confusing.
Actual vs Target vs Previous on the same line will be very interesting. What are your ideas on that one?
Also, is it possible to have the actual number display on the edge of the graph? Meaning -- on the end of the bar can we see 661 appear on the graph? I am trying to balance people who need exact numbers and people who like the overall story , trend etc..,
Thanks for this.
It's a very simple thing to add labels to marks in Tableau: just drop the desired measure -- in this case, the same measure we're illustrating with the bar -- into the Label shelf.
As for the multiple-metric issue... perhaps it would be enough to show a simple bar chart for each year's actual and a reference line for the latest target.
It seems counter-intuitive compare a previous year's actual against a current year's target, though. The bullet chart above gives you the year-by-year comparisons without losing the performance context for each individual year. Wouldn't you be handicapping the usefulness of the chart by losing that context?
You are right. What you have depicted should work. And thanks again for showing how labels can be built into this.
I am going to give this a go. Appreciate this.