I have survey data with scores (measure is called "Score") at two times: Time 1 and Time 2 (dimension is called "Test Time.") I created a bar chart using a table calculation (Worksheet: "Importance Change by Question") to show the difference in scores from Time 1 to Time 2, and I would like to have a took tip that shows the actual scores at Times 1 and Times 2. But, as the screenshot below shows, I can't get the Time 1 score to show up in the tool tip.
Here is the calculation I used for Time 1 Average Score. I used the same type of calculation for Time 2 average score.
Both of these calculations work when I put them in a table. See below. But when I put them in the tooltip, only the Time 2 score shows up. I have attached the workbook. Thanks, in advance, to the Tableau genius who can solve this mystery for me!!
-Amelia
PS. I'm using Tableau Desktop 2019.1.3
Hi
I opened the book and it is a little complex -
here is the issue - you have a dimension Time Test that you want to split into parts Tiem 1 and Time 2
using calculations like this
the statement is executed at the record level so each record is either at time 1 or a time 2 - the result is that you partition the data
and the aggregation of each part is in only one or the other partition
an approach to look at both the time 1 and the time 2 aggregates is to use LOD's
Now here is where I ran into problems - I don't know your data - structure and how you are filtering it
I tried this
then tried this and I think this might work (note on the attached I only did the 1 calc - you would need to do each "Time" and then fold the results into your other calcs
you still may need to play with it a bit to get where you want
Good luck
Jim
If this posts assists in resolving the question, please mark it helpful or as the 'correct answer' if it resolves the question. This will help other users find the same answer/resolution. Thank you.
