What about this ?
I just added some Quick Table Calculations and customised the Compute Using setting.
You can edit the alias, etc.. to get exactly the look you want and with more data it will show the difference between the current and previous month.
Help Workbook CM.twbx 14.0 KB
Thanks for taking a stab at it! Not exactly. I was hoping I could put the % difference in a separate row in each column, so that it was all aligned. I figured out how to do it by adding in a separate column, but perhaps Tableau can't do it so it's all aligned (like below).
Appreciate your willingness to help. Please see my response to Shawn. I'm trying to make it so that i don't have to build a separate column for the calculation, but that it can fit below the metrics in the same one. Not sure if that's possible or not.
Thanks for jumping in. I see what you're talking about, but unfortunately, that splits it and makes it difficult to follow the MoM.
It may not be possible in Tableau (??), but i'm hoping to keep it in the original format w/ columns, just adding on a row for each (forgive my horrible mouse drawing below). I THINK it can be done w/ the help of an equation or function as a calculated field, I just don't know what it is.
I'll say, not possible. (Of course this will engage the true geniuses around here.)
3 of 3 people found this helpful
Applying for "true genius":
@Shawn, do I win?
However, I don't recommend this kind of view (and I think Shawn will agree with me because it's a recurring theme for us here on the forums). a) it's complicated, b) it's fragile (among other potential issues if there is no data for one month then the calcs will fail), and c) there are many ways to indicate the absolute values and magnitude of difference from one month to the next that take advantage of pre-attentive processing that don't require finding the right value in a list of numbers. Here are 5 examples I put together using this data:
Line chart w/% change labels:
Bars w/% change labels:
comet/ice cream plot:
Building *all* of those 5 views together took about the same amount of time as the desired view took, there are many more that could be done that would also take less time to build, be less fragile, and communicate the desired information faster.
The kind of "mashing multiple measures into a single column" that was requested is something that we are used to doing in Excel & other spreadsheet or traditional reporting apps because it's a compact form that prints well. However text tables are only good for one thing and that is looking up exact values. For actually displaying data in a way that enables human beings to quickly make the necessary comparisons and form conclusions about text tables are among the worst of options. So please, try to find out what your users are trying to do with the data and build views that support them in those tasks (and are easier to build & maintain in Tableau).
If one really has to build a view this way, the view is constructed using a custom subtotal. The Month dimension was duplicated and Month (copy) placed on the Level of Detail Shelf, see http://drawingwithnumbers.artisart.org/customizing-grand-totals-part-2 for details. A regular % diff calc is used to generate the % difference with addressing on the Month (copy) so it only generates results in the subtotal computation. A new measure is created for the Clicks to only return results in the detail rows and not the subtotal. Here's the workout view:
Then I duplicated that worksheet, got rid of the unecessary pills, customized the Total label to say % Diff, turned off mark stacking using Analysis->Mark Stacking->Off, and just had Measure Values on the Text Shelf:
v9.0 workbook is attached.
Of course. (But no surprise)
Thank you, oh master Tableau wizard!