Hello I think this is an easy one
I have a raw data set with the below columns: The date column has the average time it takes them to complete each tasks. PLease post a yxmd thats easy to use for large data sets theres about 300 rows I'm comparing this too and this is just a short sample :
Name | Team NAme | Tasks | 1/1/2022 | 2/2/2022 | 3/3/2022 | ||||
John | Giants | Run | 3 | 1 | 2 | ||||
John | Giants | Walk | 1 | 1 | 1 | ||||
John | Giants | Play | 2 | 3 | 2 | ||||
Chris | JEts | PLay | 2 | 1 | 1 | ||||
Chris | JEts | walk | 2 | 2 | 2 | ||||
Chris | JEts | Run | 1 | 1 | 1 | ||||
I want the output to look like this:
Name | Team NAme | Tasks | Month | Sum of Hours | |||||
John | Giants | Run | 1/1/2022 | 6 | |||||
John | Giants | Walk | 2/1/2022 | 3 | |||||
John | Giants | Play | 3/1/2022 | 7 | |||||
Chris | JEts | PLay | 1/1/2022 | 4 | |||||
Chris | JEts | walk | 2/1/2022 | 6 | |||||
Chris | JEts | Run | 3/1/2022 | 3 | |||||
Solved! Go to Solution.
Hi @AntlRo
Please find the solution attached for you.
As you are expecting the Month column in output, I can still generate that for you.
But the logic is missing, in the input we have 1/1/2022, 2/2/2022 and 3/3/2022.
However in the output the expected is 1/1/2022, 2/1/2022 and 3/1/2022.
Can you explain the expectation in the month field, so I can generate the output for you as expected.
Many thanks
Shanker V
it will just be 3/1.. you can use same dates . I used the dates as an example
User | Count |
---|---|
60 | |
24 | |
24 | |
21 | |
21 |