Hi everyone,
I have a workflow with dates and I need to break out the data by the number of actions completed per month. Below is an example of how my data currently looks, followed by another table of how I want my data to look.
Item Sub-Item Group Member ID Level Date
Summit Attendee Request Summit Support Jai Patel abc123 First Level 2018-07-28 04:37:37
Summit Attendee Request Summit Support Jai Patel abc123 First level 2018-07-29 02:21:34
Summit Attendee Request Summit Support Jai Patel abc123 First level 2018-08-01 04:47:51
Alteryx Annual License Analytics Support Mark James def456 Second level 2018-09-07 06:34:18
How I would like the data to look:
Item Sub-Item Group Member ID Level 18-July 18-August 18-September
Summit Attendee Request Summit Support Jai Patel abc123 First Level 2 1
Alteryx Annual License Analytics Support Mark James def456 Second level 1
So the second table displays the same fields but displays only one record if Item, Sub-Item, Group, Member, ID, and level are the same and breaks out the date into months and displays the number completed in those months. So Jai completed two in July for Attendee Request so a 2 is displayed under the 18-July field.
Any help would be greatly appreciated. Thanks!
