Drill Total, Year, Month, Date

[moebe]

Hi
I have the requirement to give the possibility to start the date drill not with the year, but with the total.
So customer wants to see, f.e. the total PnL, then he wants to drill to the year, to the month and so on.
How can I solve this?

[Cyril_MTL_Analy]

Hey Benjamin,

We wrote a series of article about custom drilling that will enable you to reach your objective:

Here is the first one (links to the second and final posts are at the top):

Medium – 17 Apr 20

Putting 86,400 data points in a Looker visualization

Source Code

Reading time: 5 min read

Also you could look into this post:

Looker Help Center

More Powerful Data Drilling

Basic Measure Drilling One of the unique things about Looker is that it connects directly to your database. That means you can always access the freshest data, and you can always drill down to the ...