Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
I am trying everything and failing...
I have several functions I am tring to tackle.
Dont Care about the format, just need all of these Data Points
Here is the starting Table:
Name Date Live PVS LiveT/F
John Doe 7/7/17 Partner 1
Jane Doe 6/4/16 Partner 1
Jane Doe 6/6/17 Partner 1
Jane Doe Partner 0
Jane Doe 7/1/17 Partner 1
Sue Doe 7/7/17 SVC 1
Sue Doe 7/4/16 SVC 1
Sue Doe 6/6/17 SVC 1
Jack Doe SVC 0
Sue Doe 7/1/17 SVC 1
I want to have this Data yeild:
Total Productivity:
Name June July Aug ...Etc
Sue Doe: 1 4
Jack Doe: 0 0
John Doe: 1 1
Jane Doe: 2 1
Average: 1 1.5
Partner Avg: 1.5 1
SVC Avg: .5 2
Hi @amenne,
I want to confirm how you calculated the value per month per name. For example, why it should be '4' for Sue Doe in July? Why it should be '1' for John Doe in June? Also, please describe the syntax to calculate the average value.
By the way, you could refer to the workaround I mentioned in this thread.
Regards,
Yuliana Gu
User | Count |
---|---|
141 | |
113 | |
104 | |
78 | |
64 |
User | Count |
---|---|
136 | |
125 | |
107 | |
70 | |
61 |