Can we build a calendar view?

Question

Hello,

Not sure if this is possible but can we build a calendar view from Excel data in Alteryx? Essentially I want to bring in the data and transform it into a calendar view (12 months) where I can see  who is working hours work for each agent per day.

I added a sample of the data and what I would like the final product to look like.

Any help would be appreciated.

CalendarTest Data.xlsx

FrederikE · Answer

Hey @Jay2022,

Yes, You could do a Filter (but make sure it happens before the concatenation of the strings) like this:

But since this is dummy data (right?) it still is a lot, even with only entries that are more then 16 hours we end up with still a lot of agents.

New Workflow2.yxzp

Jay2022 · Answer

@FrederikE  ,First of all THANK YOU! this takes me further I could imagine. Because there are so many agents, I am thinking placing a filter where I can see only agents with a certain daily hours or higher could help cut back on the final view? Are we able to show those with a certain hours with a specific table (cell) color?

Like if agent hrs => 8 then shows in table with hrs and red, etc.

Is that possible?

thank you

FrederikE · Answer

Hey @Jay2022,

I am not quite sure what kind of Aggregation you wanted, so I just concatenated Agent + Hours (Always taken on the start day atm). Ofc. this makes it look kind of messy as there are many agents.

This works but ofc requires some additional work in order to look good.

New Workflow2.yxzp