topic Unpivot using sparksql in Dashboards & Analytics Discussions

topic Unpivot using sparksql in Dashboards & Analytics Discussions https://community.incorta.com/t5/dashboards-analytics-discussions/unpivot-using-sparksql/m-p/6711#M825 <P>HI </P><P>I have two dimensions, Ensys and CONTROLLER  and two measures KWH and Count(Site ID) .</P><P>I want to unpivot both dimensions and measure values  as per below screenshot.</P><P>Please let me know how to achieve.</P><P> </P><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="KHK_1-1758545328840.png" style="width: 601px;"><img src="https://community.incorta.com/t5/image/serverpage/image-id/2950i6B5AABAE593EB1AA/image-dimensions/601x257?v=v2" width="601" height="257" role="button" title="KHK_1-1758545328840.png" alt="KHK_1-1758545328840.png" /></span></P><P> </P><P> </P><P> </P> Mon, 22 Sep 2025 12:49:14 GMT KHK 2025-09-22T12:49:14Z Unpivot using sparksql https://community.incorta.com/t5/dashboards-analytics-discussions/unpivot-using-sparksql/m-p/6711#M825 <P>HI </P><P>I have two dimensions, Ensys and CONTROLLER  and two measures KWH and Count(Site ID) .</P><P>I want to unpivot both dimensions and measure values  as per below screenshot.</P><P>Please let me know how to achieve.</P><P> </P><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="KHK_1-1758545328840.png" style="width: 601px;"><img src="https://community.incorta.com/t5/image/serverpage/image-id/2950i6B5AABAE593EB1AA/image-dimensions/601x257?v=v2" width="601" height="257" role="button" title="KHK_1-1758545328840.png" alt="KHK_1-1758545328840.png" /></span></P><P> </P><P> </P><P> </P> Mon, 22 Sep 2025 12:49:14 GMT https://community.incorta.com/t5/dashboards-analytics-discussions/unpivot-using-sparksql/m-p/6711#M825 KHK 2025-09-22T12:49:14Z