Dashboards & Analytics 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 ...

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

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

Hide X axis column if measure is not available

I am building column dashboard where there is no business on weekend. But my chart show empty column for weekend. How can I hide weekend from chart if there is no amount/ measure to display.

How to setup a Data Alert for missing data?

Hello, I'm trying to setup a data alert when the data read from our source is not new. What happens is, sometimes our external source table has not been updated when our Incorta Schema load runs and we end up pulling in no data for 'today'. When th...