could you please share mock-up data .
please find the tableau attached.
steps I have done:
converted the 'wave' column from string to date with case statements. now dates are 1 Jan 2017, 1 July 2017 and 1 Jan 2018 as I have semester data with me.
what is to be achieved:
I need to make a tree map with hierarchy region->BU and label by improvement of measures 1,2,3 from latest wave to prior wave.
that means I need the values of measure 1,2,3 in latest wave and substract from prior wave. so I created columns latest wave and prior wave to get them dynamically but now confused how to get the difference of values among wave for that measure.
Please suggest. Tableau workbook attached.
date.twbx 706.8 KB
See attached workbook.
I added a "relative date" calculation to compute only the current semester and the last semester.
I used a table calc along that dimension to compute the difference.
I hid the past relative date.
By the way, converting your semesters to dates isn't really necessary. You could instead just parse out the year and number and just use some math like year * 2 + semester to number all semesters. This might be a bit faster but won't matter unless you have a lot of data.
date_v10.5.twbx 687.2 KB
update - I tried this with attr() and it worked! hope this is helpful for others following this post.
Thank you for the solution.
I have aggregated measures so a bit complex instead of just a measure1.
but the solution (relative dates) works! Thank you so much.