LinkedIn
Twitter
Hello
I'm visualising rule detection dashboard on my instance
I want to know what is the difference between count for drill and count as mentionned in the screenshot.
Thanks
Solved
1 ACCEPTED SOLUTION
'Count' is (probably) a count distinct of whatever the primary key in the underlying table is - that's a default measure that's included in every view. 'Count for drill' is something created by someone who has edit permissions on your LookML code. Given that it's returning the same numbers, there is a good chance it has the exact same definition. You may be able to look at the LookML definition of each measure (depending on your permissions) if you click on the cog wheel menu at the top of the column for each measure in the 'Data' pane at the bottom of the screen. You may also see a definition if you look at the field picker on the left and click on the 'i' button on the right of the field, as below.
If you can't see the LookML definition, you can always click on the 'SQL' tab that you can see to the left of 'add calculation', you can compare the SQL generated when you use either one of these measures.
'Count' is (probably) a count distinct of whatever the primary key in the underlying table is - that's a default measure that's included in every view. 'Count for drill' is something created by someone who has edit permissions on your LookML code. Given that it's returning the same numbers, there is a good chance it has the exact same definition. You may be able to look at the LookML definition of each measure (depending on your permissions) if you click on the cog wheel menu at the top of the column for each measure in the 'Data' pane at the bottom of the screen. You may also see a definition if you look at the field picker on the left and click on the 'i' button on the right of the field, as below.
If you can't see the LookML definition, you can always click on the 'SQL' tab that you can see to the left of 'add calculation', you can compare the SQL generated when you use either one of these measures.
