One of the reasons I like Tableau over Excel for visual analytics is that I can create what I want faster and simply.
Unfortunately, the functionality to mimic Tableau’s feature in adding averages and medians to a chart does not exist inside a Quantrix toolbox. In this brief video, I show you not only the technique to add an average to a chart, but also how to toggle between a data set’s average or median.
Key points to remember:
- You need to include an average calculation in the matrix being used to chart your data.
- Use an IF statement in your underlying matrix to toggle between the average and the median.
