Box and Whisker (MAQ Software) - Duration of activities.

[SACooper]

I have a table that lists among other things contains WorkItem (name of activity), AccessTime (time taken to complete activity), ProcessedDate (date activity started), Processedtime (time activity started), Index (this was added after some research but didnt help me solve the problem)

What I am aiming to do is analyse how long each activity takes to complete, (so we cna see mean, upper and lower bounds, quartiles and the outliers).

For some reason (me being a little dim) Accesstime seens to want to be summarised by count, sum, et. when my head tells me it shouldn't be. even though access time is formatted as time, the tooltips are in decimal and the results don't look accurate.

Can anyone point me in the right direction?

[v-yalanwu-msft · Accepted solution]

Hi， @SACooper ，

You could add column about duration as tooltip.

The final show:

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

[SACooper]

@v-yalanwu-msft Thank you for your help. I have created a new column Access_Time_Seconds which converts AccessTime to whole seconds and plotted that - it looks much nicer - but... not entirely sure how to add a tooltip that then formats this time as hh:nn:ss.

[v-yalanwu-msft]

Hi， @SACooper ，

Generally, value is a number type (measure or column). If the value is not a number type, the system automatically identifies it as count, and the calculation result is also a number type.
Since the duration is text in your screenshot, it is recommended to convert "hh:mm:ss" to second as value, and then use "hh:mm"ss as tooltip.

https://www.pbiusergroup.com/communities/community-home/digestviewer/viewthread?MessageKey=5b1f7362-...

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

[SACooper]

OK - managed to get the distribution looking better by adding accesstime to the Axis as well as value fields - but I still cna't fathom how to format the results (including tooltip) as time.