I am trying to create a time series chart showing how a specific ratio metric has changed over time. I have a table of events with the following schema:
timestamp,event_id,response_time
timestamp and event_id are self-explanatory. response_time is a numerical value that relates to an SLA. The ratio metric I am trying to display is the percentage compliance with the SLA.
Using the method described in this article, I am able to calculate the percentage compliance for a given period of time. However, I want to be able to display a time series chart that shows how the percentage compliance has changed over time. For the time series chart, I would like be able to calculate percentage compliance on a weekly basis, so I can show how SLA compliance is trending week-over-week.
What do I need to do to be able to show this calculated data over time? I tried converting the blending scorecard element into a time series chart, but DataStudio tells me that there is an "invalid dimension". I assume I need to specify how I wanted to dated "bucketed" (i.e. by week), but it's not clear to me how I do that. Any assistance or suggestions would be greatly appreciated!