Knowledge Drop

System activity history explore: More Granular History Created Dimension


Userlevel 2
  • Looker Staff
  • 13 replies

Last tested: Aug 18, 2020
 

These can be useful when you have to check history counts in a smaller interval during performance investigation. For this we can create a table calculations that look like the following:

Every 10 minutes

if(extract_minutes(${history.created_time})<11, "0-10",

if(extract_minutes(${history.created_time})<21, "10-20",

if(extract_minutes(${history.created_time})<31, "20-30",

if(extract_minutes(${history.created_time})<41, "30-40",

if(extract_minutes(${history.created_time})<51, "40-50","50-00"

)

)

)

)

)

 

Every 5 minutes

if(extract_minutes(${history.created_time})<6, 5,

if(extract_minutes(${history.created_time})<11, 10,

if(extract_minutes(${history.created_time})<16, 15,

if(extract_minutes(${history.created_time})<21, 20,

if(extract_minutes(${history.created_time})<26, 25, if(extract_minutes(${history.created_time})<31, 30, if(extract_minutes(${history.created_time})<36, 35, if(extract_minutes(${history.created_time})<41, 40, if(extract_minutes(${history.created_time})<46, 45, if(extract_minutes(${history.created_time})<51, 50, if(extract_minutes(${history.created_time})<56, 55,60

)

)

)

)

)

)

)

)

)

)

)

 

This content is subject to limited support.                

 

 


0 replies

Be the first to reply!

Reply