Resolved! Top 10 customers
Does anyone know the best way to populate the top 10 customers?
Does anyone know the best way to populate the top 10 customers?
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 ...