These are the kind of charts you can use when comparing actual against the target performance. Particularly in this case, I have shared how you can compare three metrics at ago.
Whereby the metrics are as follows.
Mtd target – the month to date target (what should be achieved by the current date)
Mtd actual – the month to date actual (what has been achieved by the current date)
Monthly target – the target of month.
(Cumulatively, Mtd target should be equal to Monthly target)
Example of Actual versus Target charts
Access the dashboard through this link!
A good example on how you can leverage some of the charts shared here, is this Performance Dashboard, which combines a bullet chart and other elements to compare the performance of these nine KPIs.
Access the dashboard through this link!
Conclusion
So, next time you need to compare 3 metrics at ago, try some of these charts shared in this article.
I hope this article was helpful to you. If you wish to receive more Tableau tips and tricks, kindly join our mailing list by subscribing below.
If you like the work we do and would like to work with us, drop us an email on our contacts page and we’ll reach out!
Thank you for reading!