Lead magnet - project 1.png
  • Bernard K

Actual vs Target Charts in Tableau


actual vs target charts in tableau

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

example of actual versus target charts in tableau

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.

performance dashboard in tableau comparing actual against target performance

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.

Useful: Learn how to create different charts and graphs in Tableau

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!

Black & white.jpg

About Me

More About the Author

Bernard K

Analytics Consultant | 3X Tableau Certified

Bernard is a data analytics consultant helping businesses reveal the true power of their data and bring clarity to their reporting dashboards. He loves building things and sharing knowledge on how to build dashboards that drive better outcomes.

Let’s discuss your data challenges! Let’s work together!