Dashboards & Analytics Discussions

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

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