Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!To celebrate FabCon Vienna, we are offering 50% off select exams. Ends October 3rd. Request your discount now.
Hello,
I have the below data which contains reported IT incidents of certain issue types at a local company. The request is to show the standard deviation on a monthly basis for the overall volume and per category as well while showing the average of volume and the max/min of the deviation.
What are the measures that I'd need to create this and what kind of visuals would you recommend for it?
Thank you in advance!
Case no | Date of incident | Category | Region |
100001 | 1/4/2021 | HW | EMEA |
100002 | 1/5/2021 | MDM | AMER |
100003 | 1/6/2021 | Exchange | AMER |
100004 | 1/7/2021 | MDM | AMER |
100005 | 1/8/2021 | Exchange | EMEA |
100006 | 1/9/2021 | PW | APAC |
100007 | 1/10/2021 | PW | APAC |
100008 | 1/11/2021 | CRM | APAC |
100009 | 1/12/2021 | CRM | AMER |
100010 | 1/13/2021 | HW | AMER |
100011 | 1/14/2021 | MDM | AMER |
100012 | 1/15/2021 | Exchange | EMEA |
Hello @amitchandak , thank you for the linked videos. How would you go about the differences in the dataset? In the linked video (second one) each line contains the value (distance run/covered by a specific player on a given day summed up) on which the calculation is performed. However in my dataset, each line will only have the value of 1 as the incidents are all counted separately line by line. Thank you!
User | Count |
---|---|
98 | |
76 | |
74 | |
49 | |
26 |