Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Good day!
I am trying to get the standard deviation and average per month (it will be cool if this can be drilled down up to day of the week basis) for my sample below:
DATE Count
Jan 01 2021 | 1 |
Jan 04 2021 | 368 |
Jan 02 2021 | 13 |
Jan 05 2021 | 421 |
Jan 03 2021 | 5 |
Jan 06 2021 | 526 |
Jan 07 2021 | 243 |
Jan 08 2021 | 228 |
Jan 09 2021 | 25 |
Jan 10 2021 | 8 |
Jan 11 2021 | 383 |
Jan 12 2021 | 571 |
Jan 13 2021 | 464 |
Jan 14 2021 | 194 |
Jan 15 2021 | 373 |
Jan 16 2021 | 45 |
Jan 17 2021 | 12 |
Jan 18 2021 | 485 |
Jan 19 2021 | 713 |
Jan 20 2021 | 912 |
Jan 21 2021 | 930 |
Jan 22 2021 | 1615 |
Jan 23 2021 | 161 |
Jan 24 2021 | 46 |
Jan 25 2021 | 851 |
Jan 26 2021 | 835 |
Jan 27 2021 | 695 |
Jan 28 2021 | 458 |
Jan 29 2021 | 471 |
Jan 30 2021 | 49 |
Jan 31 2021 | 10 |
Feb 01 2021 | 372 |
Feb 02 2021 | 491 |
Feb 03 2021 | 415 |
Feb 04 2021 | 238 |
Feb 05 2021 | 281 |
Feb 06 2021 | 20 |
Feb 07 2021 | 1 |
Feb 08 2021 | 302 |
Feb 09 2021 | 406 |
Feb 10 2021 | 461 |
Feb 11 2021 | 321 |
Feb 12 2021 | 32 |
Feb 13 2021 | 20 |
Feb 14 2021 | 5 |
Feb 15 2021 | 368 |
Feb 16 2021 | 386 |
Feb 17 2021 | 431 |
Feb 18 2021 | 241 |
Feb 19 2021 | 367 |
Feb 20 2021 | 17 |
Feb 21 2021 | 5 |
Feb 22 2021 | 358 |
Feb 23 2021 | 316 |
Feb 24 2021 | 323 |
Feb 25 2021 | 8 |
Feb 26 2021 | 148 |
Feb 27 2021 | 9 |
Feb 28 2021 | 1 |
Mar 01 2021 | 236 |
Mar 02 2021 | 324 |
Mar 03 2021 | 364 |
Mar 04 2021 | 142 |
Mar 05 2021 | 190 |
Mar 06 2021 | 11 |
Mar 07 2021 | 5 |
Mar 08 2021 | 193 |
Mar 09 2021 | 324 |
Mar 10 2021 | 311 |
Mar 11 2021 | 123 |
Mar 12 2021 | 185 |
Mar 13 2021 | 14 |
Mar 15 2021 | 221 |
Mar 16 2021 | 313 |
Mar 17 2021 | 352 |
Mar 18 2021 | 194 |
Mar 19 2021 | 931 |
Mar 20 2021 | 41 |
Mar 21 2021 | 2 |
Mar 22 2021 | 293 |
Mar 23 2021 | 290 |
Mar 24 2021 | 238 |
Mar 25 2021 | 95 |
Mar 26 2021 | 196 |
Mar 27 2021 | 15 |
Mar 29 2021 | 220 |
Mar 30 2021 | 281 |
Mar 31 2021 | 212 |
I tried using this formula:
what values are you expecting back?
ive attached something very basic, is this what you are looking for? you can drill up and down by adding a date table with your required fields. However I dont know what values you are expecting.
Proud to be a Super User!
User | Count |
---|---|
124 | |
108 | |
99 | |
62 | |
62 |
User | Count |
---|---|
137 | |
115 | |
102 | |
71 | |
61 |