Discussions

Incorta Reports

Team,Could you please let me know the data refresh timings in Incorta? Is the data only refreshed from the system at specific times? If so, what is the exact timeline?Regards,Alwin

Resolved! Stacked Column and Line Chart

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

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

Presentation Variable for Quarter

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

SUM of AVERAGE(Amount_granted column) grouped by (Approval Date column)

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