Need help with a service level table

[#1]

Hi All

I need some help my boss wants to see the service level for each 30min period per day. Below is a screenshot of what he wants but I have no idea how to wright the expression to calculate the result for each day. Any help would be appreciated, I can give him one column that shows the 30min periods but he wants it as it is below.

Regards

Eugene

[Colin-Albert · Accepted solution]

You will need two separate fields to hold the date and the time period, plus the fields to calculate the expression for percentage SLA.

Then you can use a pivot table with the date and time period as dimensions with your SLA measure as the expression.

Drag the date dimension above the expression column to give the chart as shown in your example.

If you can get one column of data you are 90% there.

Regards the exact expression, you will need to give more details on what your actual measures in your data are, and how you expect to calculate the percentage.

[its_anandrjs]

Hi,

Use Interval function to create time difference of 30 mins

Hope this helps

Thanks & Regards

[#4]

Hi Guys

Thanks for the prompt response. I have another problem now, the time does not just show the 24hours and load all the dates next to one another. You have to scroll down to see the next day.

I am using this in the script for the time...

[Colin-Albert]

You need to round your time field to 30 minute intervals

The data you have is holding each time value at full time accuracy to fractions of a second.

try    floor(Time(date(dIntervalStart)), 30/(24*60) ) as Time

or for 15 minute intervals           floor(Time(date(dIntervalStart)), 15/(24*60) ) as Time