Each month get excited to learn from an Incorta subject-matter expert and experienced industry professionals from every department of the organization.
Learn about the implications of de-activating NULL handling for your analytics.
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...
We would like to be able to set up automatic retries for load plans that fail. This would prevent manual user intervention each time a load plan fails. The retry could potentially work on subsequent tries and thus the user would not have to do anyt...
Kicking off my learning with Incorta. Hi everyone!
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
.png "Community Manager"){kind=icon}
.svg "Captain"){kind=icon}
