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...
Hi,I want to calculate amount for selected quarter and previous quarter using presentation variable.I have created presentation variable with quarter name and given default quarter is Q2/2024.Now I want to calculate amount for Q2/2024 and Q1/2024. ...
Hi. I have a listing table created with 100 columns and 100 rows. Now i am trying to freeze the first row of the table in listing table. how do i do it? If that cannot be done. Is there any alternate solutions for freezing the 1st row of the table?
Hi, is it possible to define a rolling sum formula in a business schema? I would like to sum up totals from 2 preceding rows and 'current row' for each row, and based on the dimensions added to the insight, I want this total to update.This is what I ...
Hi Team, can anyone help me with the formula for calculating growth of previous FYTD. Fiscal year starts on April 1st and ends on Aug 31st.
