Incorta Community

SUM of AVERAGE(Amount) grouped by Approval Date

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

Running totals

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

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

First Version

Hi,Could you please someone explain me how "First Version" function works?Formula:sum( firstVersion( EBS_GL.GL_BALANCES.BEGIN_BALANCE_DR_BEQ - EBS_GL.GL_BALANCES.BEGIN_BALANCE_CR_BEQ, EBS_GL.GL_BALANCES.CODE_COMBINATION_...

Automatic Date Column Filtering in Incorta Business Schema

Hi all,In the Incorta dashboard, when a user is using any date column, the selection is dynamically evaluated, and all data for the corresponding month of the selected date is displayed. We aim to implement this functionality in the Business Schema t...

News and Announcements

Knowledgebase

Product Ideas

.

Community Activity