Hi,I am trying to create a slicer with dropdown option, getting below error. "Cannot destructure property 'label' of '(intermediate value)(intermediate value)(intermediate value)' as it is null". Can anyone let me know why am getting this error?How t...

Hi,Period_Name like 08-25,09-25 .i want to Create a formula column Year from Period name and store Current year and past two years in that year column like below . Next year dynamically change the values to 2024,2025 and 2026. Please let me know how ...

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.    

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 ...

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...