<?xml version="1.0" encoding="UTF-8"?><oembed><type>video</type><version>1.0</version><html>&lt;iframe src=&quot;https://www.loom.com/embed/87bc1a6c63fe4e8dbfe69a50da71cc4a&quot; frameborder=&quot;0&quot; width=&quot;3840&quot; height=&quot;2880&quot; webkitallowfullscreen mozallowfullscreen allowfullscreen&gt;&lt;/iframe&gt;</html><height>2880</height><width>3840</width><provider_name>Loom</provider_name><provider_url>https://www.loom.com</provider_url><thumbnail_height>2880</thumbnail_height><thumbnail_width>3840</thumbnail_width><thumbnail_url>https://cdn.loom.com/sessions/thumbnails/87bc1a6c63fe4e8dbfe69a50da71cc4a-eb0d3ceec3038a72.gif</thumbnail_url><duration>201.357</duration><title>33 - Reports - Grouping Data by Department in Heat Maps 📊</title><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.</description></oembed>