The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredCompete to become Power BI Data Viz World Champion! First round ends August 18th. Get started.
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!