Forum Discussion

heli's avatar
heli
Regular Visitor
9 years ago
Solved

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/Minut...
Need Help
  • v-jiascu-msft's avatar
    v-jiascu-msft
    9 years ago

    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

     

v-jiascu-msft's avatar
v-jiascu-msft
Microsoft Employee
9 years ago

Hi heli

 

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

 

Best Regards!
Dale