Consolidated Calendar view for multiple users

Question

&nbsp;Hi ,&nbsp;Can anyone help or give pointers on building below view using source below it?&nbsp;I tried using matrix chart , unfortunately , it is aggregating values ( Shift/Value) .So I am getting only single value instead&nbsp; of mutliple values. Also , I am not interested in concantating the Values , I need seperate row for each new value.&nbsp;User NameTeam12/9/201912/10/201912/11/201912/12/201912/13/2019Name 1Team AFirstFirstFirstFirstFirst&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;OT - Accepted (Liq Pkg) - 4:45Hrs&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Vacation - Pending (Starts At 07:00 For 8:30 Hrs)&nbsp;Name 2Team AFirstFirstFirstFirstFirst&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Name 3Team AFirstFirstFirstFirstTardy - 01:15&nbsp;TeamUser NameDateShift/ValueTeam AName 112/9/2019FirstTeam AName 112/10/2019FirstTeam AName 112/11/2019FirstTeam AName 112/12/2019FirstTeam AName 112/13/2019FirstTeam AName 112/14/2019FirstTeam AName 112/15/2019FirstTeam AName 212/9/2019FirstTeam AName 212/10/2019FirstTeam AName 212/11/2019FirstTeam AName 212/12/2019FirstTeam AName 212/12/2019Vacation - Pending (Starts At 07:00 For 8:30 Hrs)Team AName 212/12/2019OT - Accepted (Liq Pkg) - 4:45HrsTeam AName 212/13/2019FirstTeam AName 212/14/2019FirstTeam AName 212/15/2019FirstTeam AName 312/9/2019FirstTeam AName 312/10/2019FirstTeam AName 312/11/2019FirstTeam AName 312/12/2019FirstTeam AName 312/13/2019FirstTeam AName 312/13/2019Flex in/Flex Out - Pending (Starts At 14:00 For 2:00 Hrs)Team AName 312/13/2019Business Travel - Approved (Starts At 08:00 For 8:00 Hrs)Team AName 312/13/2019Tardy - 00:45Team AName 312/14/2019FirstTeam AName 312/15/2019First&nbsp;Thanks,Rajesh

dax · Accepted Answer

Hi dzrajesh,
You could tryto refer to my sample for details.
Best Regards,Zoe Zhi
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Forum Discussion

Consolidated Calendar view for multiple users

2 Replies

Related content

Multiple Calendars

Calendar Slicer with Different Business Calendars

Custom calendar

Tweaking Financial Calendar

Consolidating multiple data items into fewr choices

User Name	Team	12/9/2019	12/10/2019	12/11/2019	12/12/2019	12/13/2019
Name 1	Team A	First	First	First	First	First
					OT - Accepted (Liq Pkg) - 4:45Hrs
					Vacation - Pending (Starts At 07:00 For 8:30 Hrs)
Name 2	Team A	First	First	First	First	First



Name 3	Team A	First	First	First	First	Tardy - 01:15

Team	User Name	Date	Shift/Value
Team A	Name 1	12/9/2019	First
Team A	Name 1	12/10/2019	First
Team A	Name 1	12/11/2019	First
Team A	Name 1	12/12/2019	First
Team A	Name 1	12/13/2019	First
Team A	Name 1	12/14/2019	First
Team A	Name 1	12/15/2019	First
Team A	Name 2	12/9/2019	First
Team A	Name 2	12/10/2019	First
Team A	Name 2	12/11/2019	First
Team A	Name 2	12/12/2019	First
Team A	Name 2	12/12/2019	Vacation - Pending (Starts At 07:00 For 8:30 Hrs)
Team A	Name 2	12/12/2019	OT - Accepted (Liq Pkg) - 4:45Hrs
Team A	Name 2	12/13/2019	First
Team A	Name 2	12/14/2019	First
Team A	Name 2	12/15/2019	First
Team A	Name 3	12/9/2019	First
Team A	Name 3	12/10/2019	First
Team A	Name 3	12/11/2019	First
Team A	Name 3	12/12/2019	First
Team A	Name 3	12/13/2019	First
Team A	Name 3	12/13/2019	Flex in/Flex Out - Pending (Starts At 14:00 For 2:00 Hrs)
Team A	Name 3	12/13/2019	Business Travel - Approved (Starts At 08:00 For 8:00 Hrs)
Team A	Name 3	12/13/2019	Tardy - 00:45
Team A	Name 3	12/14/2019	First
Team A	Name 3	12/15/2019	First