Forum Discussion
Radar chart with multiple tables and measures
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:
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).
1 Reply
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.
