Knowledge Drop

# System activity history explore: More Granular History Created Dimension

Userlevel 2
• Looker Staff
• 16 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!