Makeover Monday – Myers Briggs Frequencies

Makeover Monday – Myers Briggs Frequencies

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:

MB Calc Type - Copy
Type Calculation
MB Calc Char - Copy
Characteristic Calculation






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!




One thought on “Makeover Monday – Myers Briggs Frequencies

  1. Why parameters instead of filters?
    In the first view, I needed to include all of the Es without having them appear as a column in the view. By using a parameter I can change two fields – characteristics and values – with a single control.

    In the second view, I needed to show all personality types in the view. The parameter is more of a sort by… instead of a filter.


Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s