Logic behind "drill_fields" that gets auto-generated when we "create view from table" (Community)

View the original community article here

Last tested: Jul 2, 2019
 

When a view file is generated by "create view from table", measures(count) gets created with drill_fields with the following fields:

• count fields
• joined in IDs from other views auto-joined (when multiple views/project is created)
• the primary key
• dimensions that end with name or created_time

After this, the drill_fields parameter is created. It may or may not involve a set:

• If the number of fields from above is > 5, then a set called "details" is created.
• If the number of fields from above is < 5, then the drill_fields parameter is added directly to the measure like so:
  • drill_fields: [id, users.id, users.first_name, users.last_name]