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. ...
How can I create a KPI with a formula that contains the following: SUM of AVERAGE(Amount_granted column) grouped by (Approval Date column)i want the right formula that give me Total of average amount_granted group by approval date
I've created an aggregate dashboard with attached layout (linked to JDE). The business wants to see the individual transaction with qty and amounts as well as having a running total column against each of the respective records. This is to assist in ...
What is the best way to use the Stacked Column and Line Chart for customers while getting the left/right axis to behave?Right now, I have a dashboard using that visualization type in Incorta, but the left/right y axis seem to have minds of their own....
.svg "Captain"){kind=icon}
