Pivoting by Custom Measure/Table Calculation

[jvullo]

Hi,

I made a table calculation with a nested if statement to label a numeric column with an interval range (i.e. if( field>=20, “20+”, if( field >= 10, “10 - 19”, “5 - 9”))

I was wondering if it is possible to pivot by this field to have these labels as the columns in the pivot and have counts for the users that fall in each category as the values.

Is this possible? I don’t see the option to pivot by a custom measure/table calculation.

Thanks!

[rtruxler]

This is possible, but it is a little cumbersome. First, select the columns you want in the explore tab, then go into the SQL Editor, modify the query to include your calculation (make sure it is one of the group by fields). Click “Run” to load some results, then click the Gear icon > Explore. This will bring you back to the explore view where you now have the ability to promote your calculated field to a pivot.