Peak througput (count per second)

[heli]

Hi!

I have table that contains the date/time of a signature done by a user since a couple of months. I have duplicated the "Sig Date" column in order to have a dedicated column for the Hour/Minute/Second. That way I can see the SUM of signatures per Hour/Minute/Second.

However, it shows the SUM over the full time period of the table.

What I would like to do next is a line chart that shows the throughput (signatures per second). Y-Axis contains a measure signature per second and X-Axis contains the timeline (ideally this can be drilled down from year down to a day).

The goal is to see the throuput (how many signatures per second) that can be drilled down to a day, showing the signatures per second over a particular day. It should then be possible to identify the peak month or day and drill it down to get the peak hour or even minute where the highest througput was reached. That would also help to understand the peak load that was processed (instead of some sum or averages values).

How could this be achieved? Any hints?

[v-jiascu-msft]

Hi @heli

Could you please tell me if the solution worked? Please mark it as answer if it worked.

Best Regards!
Dale

[v-jiascu-msft · Accepted solution]

@heli

Hi,

You have done a good job. The structure of the table is good for hierarchy. We just need create a custom hierarchy.

1. Right click on “SigHour”, choose “New hierarchy”;
2. Add “SigMinute”, “SigSecond” to “SigHour Hierarchy”;
3. Create visual as the picture showed. You can drill down to second now.

Best Regards!

Dale

[vanessafvg]

@heli

have you created a separate date table?

i would separate out the dates into a different table.  I.e

1. create a date table

2. create a relationship between your sign date and the date in the date table

from the little information you have given that might solve the issue, to create a date table see here

https://www.mattmasson.com/2014/02/creating-a-date-dimension-with-a-power-query-script/