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 : NameTeam NAmeTasks1/1/20222/2/2022 3/3/2022 JohnGiantsRun312 JohnGiantsWalk111 JohnGiantsPlay232 ChrisJEtsPLay211 ChrisJEtswalk222 ChrisJEtsRun111 I want the output to look like this: NameTeam NAmeTasksMonthSum of Hours JohnGiantsRun1/1/2022 6 JohnGiantsWalk2/1/20223 JohnGiantsPlay3/1/20227 ChrisJEtsPLay1/1/20224 ChrisJEtswalk2/1/20226 ChrisJEtsRun3/1/20223

Move dates from columns to rows along with hours

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

Datasets

Developer Tools

Tips and Tricks

Data Investigation

Accepted answers

ShankerV

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

All comments

MatthewO

@AntlRo attached is a sample of how you may be able to approach this. I don't follow how your output is being calculated, and the example doesn't achieve the same results, but with some modifications it may get you there. If you can clarify the calculation for the Hours field, happy to take another pass.