cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Regular Visitor

Peak througput (count per second)

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?

 

powerbi.pngsignatures.png

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
Microsoft
Microsoft

Re: Peak througput (count per second)

@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.Peak througput (count per second) .jpg

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

Best Regards!

Dale

 

Community Support Team _ Dale
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

3 REPLIES 3
Highlighted
Super User I
Super User I

Re: Peak througput (count per second)

@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/





Did I answer your question? Mark my post as a solution!

Proud to be a Super User!




Highlighted
Microsoft
Microsoft

Re: Peak througput (count per second)

@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.Peak througput (count per second) .jpg

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

Best Regards!

Dale

 

Community Support Team _ Dale
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

Highlighted
Microsoft
Microsoft

Re: Peak througput (count per second)

Hi @heli

 

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

 

Best Regards!
Dale

Community Support Team _ Dale
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Helpful resources

Announcements
May 2020 Community Highlights

May 2020 Community Highlights

It’s time for another PBI Community recap!

Community Blog

Community Blog

Visit our Community Blog for articles, guides, and information created by fellow community members.

Using the Community

Using the Community

Need help with the Power BI Community? Our 'Using the Community' support articles are a great place to start.

Galleries

Galleries

Looking for inspiration on how to present your data? Need instructional videos? Check out our Galleries!

Top Solution Authors