ErickGaitan Tracker

Re: Unable to calculate Standard Deviation results are different compared to Excel

ErickGaitan — Thu, 02 Jan 2025 16:43:52 GMT

I did, I calculate the average first, and them a use the STDEVX.S formula base on the measure, what should I do?

Re: Unable to calculate Standard Deviation results are different compared to Excel

ErickGaitan — Thu, 02 Jan 2025 15:34:24 GMT

It did not work, the issues is that power BI use the column to calculate the standard deviation, but I want to make the calculation base on a measure...that is the reason why the result are not matching. In excel first I did an average and after that I use the standard deviation, I tried to do the same in power BI, but the result is different

Unable to calculate Standard Deviation results are different compared to Excel

ErickGaitan — Thu, 26 Dec 2024 14:51:11 GMT

CSATest	Volume	Impact
80	0.75%	-0.037593985	21.10898
89.23076923	2.44%	0.103383459
33.33333333	1.69%	-0.87406015
72.85714286	2.63%	-0.319548872
20	0.19%	-0.122180451
80	0.38%	-0.018796992
82.85714286	1.32%	-0.028195489
68	1.88%	-0.319548872
68	0.94%	-0.159774436
40	0.19%	-0.084586466
100	2.82%	0.422932331
43.33333333	1.13%	-0.469924812
63.33333333	1.13%	-0.244360902
54.28571429	1.32%	-0.404135338
60	0.19%	-0.046992481
96.66666667	1.13%	0.131578947
60.47619048	23.68%	-5.808270677
100	1.88%	0.281954887
100	0.56%	0.084586466
48.33333333	2.26%	-0.827067669
81.9047619	3.95%	-0.122180451
60	0.75%	-0.187969925
60	0.75%	-0.187969925
48	0.94%	-0.347744361
73.84615385	2.44%	-0.272556391
77.5	1.50%	-0.112781955
40	0.19%	-0.084586466
76	0.94%	-0.084586466
100	0.56%	0.084586466
70	0.38%	-0.056390977
100	0.19%	0.028195489
90	1.50%	0.07518797
68	0.94%	-0.159774436
50	1.50%	-0.526315789
60	2.82%	-0.704887218
46.66666667	0.56%	-0.216165414
80	1.50%	-0.07518797
90	0.75%	0.037593985
100	0.56%	0.084586466
80	0.19%	-0.009398496
80	1.69%	-0.084586466
66.66666667	1.13%	-0.206766917
56.66666667	1.13%	-0.319548872
100	0.19%	0.028195489
20	0.19%	-0.122180451
77.14285714	1.32%	-0.103383459
100	0.19%	0.028195489
76.66666667	3.38%	-0.281954887
70	0.75%	-0.112781955
50	1.50%	-0.526315789
73.33333333	1.13%	-0.131578947
71.85185185	5.08%	-0.667293233
90	0.38%	0.018796992
65	0.75%	-0.15037594
76.66666667	2.26%	-0.187969925
100	0.19%	0.028195489
50	0.38%	-0.131578947
50	0.75%	-0.263157895
80	0.75%	-0.037593985
20	0.19%	-0.122180451
60	1.13%	-0.281954887
65.71428571	1.32%	-0.253759398
75	0.75%	-0.07518797
66.66666667	0.56%	-0.103383459
100	0.75%	0.112781955
40	0.75%	-0.338345865

Column test is an average

I tried the following measure in Power BI and the result is different:

desviacion = STDEVX.S('Raw Data','Raw Data'[Q1 - How satisfied were you with the service offered by the Miele Contact Center...])

Re: How to compare two the time scheduled vs time actual

ErickGaitan — Thu, 27 Oct 2022 14:52:21 GMT

10/9/2022

08:30 AM

00:12:37

08:30 AM

00:15:00

In this case if compare the first time frame vs second time frame: its 0 because the break was taken at the scheduled time frame, but if the agent for some reason take the break at a difference time frame I would like to know the difference in minuntes

E.X

Break segments was scheduled at 10 am and the agent took the segment at 8.55 am

10:00 AM

00:08:22

08:55 AM

00:15:00

How to compare two the time scheduled vs time actual

ErickGaitan — Wed, 26 Oct 2022 15:34:52 GMT

Good day community,

I have to compare the time the agent took break vs the time schedule break.

First, I would like to identify which was the first break and the second break, both are in the same columm.

Second, compare the 2 time frames. I have noticed that PBI filled the rows blank and duplicate the information as you can see below.

I have been working on this for a month and I feel frustrated at this point

find below the data Sample

I want to compare the difference in minutes between DTS column and start time column.

Date	DTS Test	Break Time	Lunch Time	Start Time	Break-1 Sch	Break-2 Sch	Lunch Sch
10/9/2022	06:30 AM			08:30 AM	00:15:00
10/9/2022	06:30 AM			10:30 AM			01:00:00
10/9/2022	06:30 AM			01:45 PM		00:15:00
10/9/2022	07:00 AM			08:30 AM	00:15:00
10/9/2022	07:00 AM			10:30 AM			01:00:00
10/9/2022	07:00 AM			01:45 PM		00:15:00
10/9/2022	08:30 AM	00:12:37		08:30 AM	00:15:00
10/9/2022	08:30 AM	00:12:37		10:30 AM			01:00:00
10/9/2022	08:30 AM	00:12:37		01:45 PM		00:15:00
10/9/2022	09:00 AM	00:02:23		08:30 AM	00:15:00
10/9/2022	09:00 AM	00:02:23		10:30 AM			01:00:00
10/9/2022	09:00 AM	00:02:23		01:45 PM		00:15:00
10/9/2022	10:30 AM	00:02:00		08:30 AM	00:15:00
10/9/2022	10:30 AM	00:02:00		10:30 AM			01:00:00
10/9/2022	10:30 AM	00:02:00		01:45 PM		00:15:00
10/9/2022	12:00 PM		00:29:29	08:30 AM	00:15:00
10/9/2022	12:00 PM		00:29:29	10:30 AM			01:00:00
10/9/2022	12:00 PM		00:29:29	01:45 PM		00:15:00
10/9/2022	12:30 PM		00:30:00	08:30 AM	00:15:00
10/9/2022	12:30 PM		00:30:00	10:30 AM			01:00:00
10/9/2022	12:30 PM		00:30:00	01:45 PM		00:15:00
10/9/2022	01:00 PM		00:00:30	08:30 AM	00:15:00
10/9/2022	01:00 PM		00:00:30	10:30 AM			01:00:00
10/9/2022	01:00 PM		00:00:30	01:45 PM		00:15:00
10/9/2022	02:30 PM	00:13:01		08:30 AM	00:15:00
10/9/2022	02:30 PM	00:13:01		10:30 AM			01:00:00
10/9/2022	02:30 PM	00:13:01		01:45 PM		00:15:00
10/9/2022	04:00 PM			08:30 AM	00:15:00
10/9/2022	04:00 PM			10:30 AM			01:00:00
10/9/2022	04:00 PM			01:45 PM		00:15:00
10/9/2022	06:30 AM			08:00 AM			00:15:00
10/9/2022	06:30 AM			11:00 AM			01:00:00
10/9/2022	06:30 AM			02:00 PM			00:15:00
10/9/2022	07:00 AM			08:00 AM			00:15:00
10/9/2022	07:00 AM			11:00 AM			01:00:00
10/9/2022	07:00 AM			02:00 PM			00:15:00
10/9/2022	09:00 AM	00:15:00		08:00 AM			00:15:00
10/9/2022	09:00 AM	00:15:00		11:00 AM			01:00:00
10/9/2022	09:00 AM	00:15:00		02:00 PM			00:15:00
10/9/2022	11:00 AM		00:29:26	08:00 AM			00:15:00
10/9/2022	11:00 AM		00:29:26	11:00 AM			01:00:00
10/9/2022	11:00 AM		00:29:26	02:00 PM			00:15:00
10/9/2022	11:30 AM		00:30:00	08:00 AM			00:15:00
10/9/2022	11:30 AM		00:30:00	11:00 AM			01:00:00
10/9/2022	11:30 AM		00:30:00	02:00 PM			00:15:00
10/9/2022	12:00 PM		00:00:34	08:00 AM			00:15:00
10/9/2022	12:00 PM		00:00:34	11:00 AM			01:00:00
10/9/2022	12:00 PM		00:00:34	02:00 PM			00:15:00
10/9/2022	01:30 PM	00:11:11		08:00 AM			00:15:00
10/9/2022	01:30 PM	00:11:11		11:00 AM			01:00:00
10/9/2022	01:30 PM	00:11:11		02:00 PM			00:15:00
10/9/2022	02:00 PM	00:03:51		08:00 AM			00:15:00
10/9/2022	02:00 PM	00:03:51		11:00 AM			01:00:00
10/9/2022	02:00 PM	00:03:51		02:00 PM			00:15:00
10/9/2022	04:00 PM			08:00 AM			00:15:00
10/9/2022	04:00 PM			11:00 AM			01:00:00
10/9/2022	04:00 PM			02:00 PM			00:15:00
10/9/2022	06:30 AM			08:30 AM	00:15:00
10/9/2022	06:30 AM			10:30 AM			01:00:00
10/9/2022	06:30 AM			01:50 PM		00:15:00
10/9/2022	08:00 AM	00:07:24		08:30 AM	00:15:00
10/9/2022	08:00 AM	00:07:24		10:30 AM			01:00:00
10/9/2022	08:00 AM	00:07:24		01:50 PM		00:15:00
10/9/2022	08:30 AM	00:07:56		08:30 AM	00:15:00
10/9/2022	08:30 AM	00:07:56		10:30 AM			01:00:00
10/9/2022	08:30 AM	00:07:56		01:50 PM		00:15:00
10/9/2022	12:00 PM		00:23:39	08:30 AM	00:15:00
10/9/2022	12:00 PM		00:23:39	10:30 AM			01:00:00
10/9/2022	12:00 PM		00:23:39	01:50 PM		00:15:00
10/9/2022	12:30 PM		00:30:00	08:30 AM	00:15:00
10/9/2022	12:30 PM		00:30:00	10:30 AM			01:00:00
10/9/2022	12:30 PM		00:30:00	01:50 PM		00:15:00
10/9/2022	01:00 PM		00:06:21	08:30 AM	00:15:00
10/9/2022	01:00 PM		00:06:21	10:30 AM			01:00:00
10/9/2022	01:00 PM		00:06:21	01:50 PM		00:15:00
10/9/2022	01:30 PM	00:00:03		08:30 AM	00:15:00
10/9/2022	01:30 PM	00:00:03		10:30 AM			01:00:00
10/9/2022	01:30 PM	00:00:03		01:50 PM		00:15:00
10/9/2022	02:00 PM	00:13:56		08:30 AM	00:15:00
10/9/2022	02:00 PM	00:13:56		10:30 AM			01:00:00
10/9/2022	02:00 PM	00:13:56		01:50 PM		00:15:00
10/9/2022	04:00 PM			08:30 AM	00:15:00
10/9/2022	04:00 PM			10:30 AM			01:00:00
10/9/2022	04:00 PM			01:50 PM		00:15:00
10/9/2022	06:30 AM			08:55 AM	00:15:00
10/9/2022	06:30 AM			10:30 AM			01:00:00
10/9/2022	06:30 AM			02:05 PM		00:15:00
10/9/2022	07:00 AM			08:55 AM	00:15:00
10/9/2022	07:00 AM			10:30 AM			01:00:00
10/9/2022	07:00 AM			02:05 PM		00:15:00
10/9/2022	09:00 AM	00:08:22		08:55 AM	00:15:00
10/9/2022	09:00 AM	00:08:22		10:30 AM			01:00:00
10/9/2022	09:00 AM	00:08:22		02:05 PM		00:15:00
10/9/2022	09:30 AM	00:09:30		08:55 AM	00:15:00
10/9/2022	09:30 AM	00:09:30		10:30 AM			01:00:00
10/9/2022	09:30 AM	00:09:30		02:05 PM		00:15:00
10/9/2022	12:00 PM		00:24:18	08:55 AM	00:15:00
10/9/2022	12:00 PM		00:24:18	10:30 AM			01:00:00
10/9/2022	12:00 PM		00:24:18	02:05 PM		00:15:00
10/9/2022	12:30 PM		00:30:00	08:55 AM	00:15:00
10/9/2022	12:30 PM		00:30:00	10:30 AM			01:00:00
10/9/2022	12:30 PM		00:30:00	02:05 PM		00:15:00
10/9/2022	01:00 PM		00:05:43	08:55 AM	00:15:00
10/9/2022	01:00 PM		00:05:43	10:30 AM			01:00:00
10/9/2022	01:00 PM		00:05:43	02:05 PM		00:15:00

Re: Sum hours for night shift employees

ErickGaitan — Fri, 30 Sep 2022 03:50:30 GMT

9/1/2022 0:00 this is the start day, it is the first segment of the day, what i am looking for is sum the hours based on the nominal day, when they started the shift

Re: Sum hours for night shift employees

ErickGaitan — Fri, 30 Sep 2022 00:00:06 GMT

I usually split the columns to get the date and the intervals

Sum hours for night shift employees

ErickGaitan — Fri, 30 Sep 2022 17:42:11 GMT

Solution: https://community.powerbi.com/t5/Desktop/Shift-that-Goes-into-Next-day/m-p/2690043#M941771

Good day community,

I need help, I am trying to sum the total amount of hours worked by each employee, to measeure the complaince, the have a certain amount of hour scheduled. My problem is that could not sum accuratly the hour work by the graveyard agent: They usually start shift at 6.00 pm, 7.00 pm or 9.00 pm. They end the shift the next day but the hours should count in the previous day; which is the nominal day, is there any way to make this possible?

Interval	Hours
9/1/2022 0:00	1800
9/1/2022 0:00	1800
9/1/2022 0:00	1800
9/1/2022 0:00	1800
9/1/2022 0:00	1800
9/1/2022 0:00	1800
9/1/2022 0:00	1800
9/1/2022 0:00	1800
9/1/2022 0:00	1800
9/1/2022 0:30	1800
9/1/2022 0:30	1800
9/1/2022 0:30	1800
9/1/2022 0:30	1800
9/1/2022 0:30	0
9/1/2022 0:30	0
9/1/2022 0:30	0
9/1/2022 0:30	0
9/1/2022 0:30	0
9/1/2022 1:00	0
9/1/2022 1:00	0
9/1/2022 1:00	0
9/1/2022 1:00	0
9/1/2022 1:00	0
9/1/2022 1:00	1800
9/1/2022 1:00	1800
9/1/2022 1:00	1800
9/1/2022 1:00	1800
9/1/2022 1:30	1800
9/1/2022 1:30	1800
9/1/2022 1:30	1800
9/1/2022 1:30	1800
9/1/2022 1:30	1800
9/1/2022 1:30	1800
9/1/2022 1:30	1800
9/1/2022 1:30	1800
9/1/2022 1:30	1800
9/1/2022 20:00	1800
9/2/2022 20:30	1800
9/3/2022 21:00	1800
9/4/2022 21:30	1800
9/5/2022 22:00	1800
9/6/2022 22:30	1800
9/7/2022 23:00	0
9/8/2022 23:30	0
9/10/2022 0:00	0