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

Knowledge Drop

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]

This content is subject to limited support.                

Version history
Last update:
‎05-07-2021 09:03 AM
Updated by: