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.
Forum Posts
Sum of 3 months of Measure to show as quarter value
Hi , I have below requirementIf one customer have revenue for three months like Jan,Feb.Mar(Q1).Jan=100Feb=20Mar=30Sum of Jan +Feb+Mar=150This 150 value show in separate column to show 3 times in the report as below. I want to calculate the Ratio by ...
How to Configure Dashboard Parameters with Default Values and Dropdown List from -100 to 100 in Incorta?
Hello ,I have a requirement to configure two dashboard parameters: “No of Days” and “Total Days”.By default, these parameters should take values 1 and 10 respectively.At the same time, users should be able to select any value between -100 and 100 fro...
Resolved! Top 10 customers
Does anyone know the best way to populate the top 10 customers?
Row Number in Spark SQL MV
Hi,I have below Oracle Query and i want to convert the query to Spark SQL . Please let me know how to write Rownum condition in spark sql.Sample Oracle Query:selectpes.event_num,glp.period_name,(SELECT conversion_rate FROM gl_daily_ratesWHERE from_cu...
