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

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.