Lots of Data Structuring, Parameters, and Calculations in this week’s makeover!
Check out the interactive version here!
To create the first view, with each letter (I, E, N, S…) side by side along a single axis, I had to duplicate the data source, and pivot the category fields. Then, to filter the data as parameters are selected, I had to go back to the original data source and add a ‘Type’ field. This essentially acts as an ID, tying E/I; E; 2% to S/N; S; 2% within ENTP.
Original & Revised Data Sources
From there, it took a whole mess of filters and calculations to get the parameters to remove the categories and filter by the chosen Value.
Calculations behind the filters:
I really like the second view, because it specifically calls out similar and dissimilar personality types. Whenever I look at my own Myers-Briggs results (or results for similar tests), I’m always checking out my ‘neighbors’ and ‘opposites’. Results are rarely grouped to facilitate this sort of exploration, so this was my chance to re-organize the types. Plus, it creates a fairly pleasing bell curve!
This view uses the original data source. The set of calculations powering this view compare the Category fields to the Type parameter, using Contains() to return Boolean values. Another calculation turns the Boolean values into integers and sums them on a row/personality type level.
Reference lines show the expected values, using the calculation 1/16.
What I wasn’t able to do: Create an action linking the first view to the second. There’s no ‘Set a Parameter’ Dashboard Action!