Discussions

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

Removing Duplicates in a listing table

I was trying to create a very simple listing table of a few columns (Brokers name, Sales office, customer). It works however it is displaying duplicate rows of data. Is there a way to do a distinct on a listing table? Or is there a way to remove dupl...