View the original community article here
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.