Radar chart with multiple tables and measures

[fernandesdiego]

I am struggling to find a way to prepare the data, as the chart need the categories to be on the rows and I have them as measures and calculated columns, so I am not sure I can "unpivot" my tables in a way that would make this possible.

Some context:

Spoiler

Users

UserId	UserName
1	John
2	Jane

Incidents

ID	UserId	Date	Time to Resolve
20	1	mm/dd/YYYY HH:mm	2:00:00
30	2	mm/dd/YYYY HH:mm	1:00:00
40	2	mm/dd/YYYY HH:mm	0:30:00

Calls

Id	UserId	Date	Handling Time	Speed to Answer
123	1	mm/dd/YYYY HH:mm	00:15:00	00:10:00
124	1	mm/dd/YYYY HH:mm	00:10:00	00:12:00
125	2	mm/dd/YYYY HH:mm	00:23:00	00:09:00

Calendar

Date

01/01/2024

01/02/2024

01/03/2024

[...]

Example: when I have a visual with the user name, I can create a measurement to calculate its average handling time, another to time to resolve incident, and use the calendar dates as a slicer to filter both tables at once.

I want to build something similar to this

Users have many incidents and calls, and I use the calendar table to filter them by date. There are more but I need only these for now. I will use min-max normalization on my measures to show a fixed range on the chart (0-1).

[lbendlin]

Your data is already in a suitable format, no need to unpivot.  You should be able to link up your data model from the calendar table and the users table and then add the normalized measures to the radar chart, with the users as Legend and the date as filter.