Dashboards & Analytics Discussions
cancel
Showing results for 
Search instead for 
Did you mean: 

Forum Posts

calculate data for 10 rolling Quarters

Hi, I want to Calculate data for 10 rolling Quarters.I have created Session variable using Current date ,QTR format is 2025-Q4. I have created Presentation variable using above created Session variable.now i want create a formula to calculate data fr...

KKR by Rocketeer
  • 57 Views
  • 0 replies
  • 0 kudos

Unpivot using sparksql

HI I have two dimensions, Ensys and CONTROLLER  and two measures KWH and Count(Site ID) .I want to unpivot both dimensions and measure values  as per below screenshot.Please let me know how to achieve.    

KHK_1-1758545328840.png
KHK by Partner
  • 254 Views
  • 0 replies
  • 0 kudos