{"type":"video","version":"1.0","html":"<iframe src=\"https://www.loom.com/embed/87bc1a6c63fe4e8dbfe69a50da71cc4a\" frameborder=\"0\" width=\"3840\" height=\"2880\" webkitallowfullscreen mozallowfullscreen allowfullscreen></iframe>","height":2880,"width":3840,"provider_name":"Loom","provider_url":"https://www.loom.com","thumbnail_height":2880,"thumbnail_width":3840,"thumbnail_url":"https://cdn.loom.com/sessions/thumbnails/87bc1a6c63fe4e8dbfe69a50da71cc4a-eb0d3ceec3038a72.gif","duration":201.357,"title":"33 - Reports - Grouping Data by Department in Heat Maps 📊","description":"In this video, I walk you through the process of grouping our heat map by department. We start by loading all distinct department IDs into a table and then set up a parameter for our queries. I demonstrate how to create a group header based on the department ID and how to incorporate the department name into the master data. After making these adjustments, we successfully generate a pivot table that is now grouped by department. If you have any questions or need further assistance, please reach out on the forums where our developers are ready to help."}