Dashboards & Analytics Discussions

Resolved! Rolling Sum + Max Condition

Hi,I'm trying to achieve a rolling sum with a max condition. Basically trying to do a rolling sum but before we roll the 1st row sum to the next row we have to check with a condition if the rolling value is less than or equal to Zero. If it is less t...

Aggregation

I'm trying to create an agg table where I'd like to show a distinct aggregation with counts > 1. The aggregation has a base field. It looks like this: "Journal Header Id" - Base Field = "Journal Line Num", Aggregation = DISTINCT I want to show that a...

Resolved! Copilot is not working

Hi,Recently, I upgraded our incorta instance with latest version. But I couldn't get result if I ask the question using Copilot.I have provided below information under cluster configuration under incorta copilot.1) OpenAI Text Completion Token2) Open...

Resolved! Changing coloring Dimensions in the graph

Hi - Is there a way to change the default colors in the coloring dimension, in the graphical insights?

Running total % error

I have two column which has formula created inside the insight. Both these columns are running total.Now I want to calculate percentage using these two columns, which is giving error. How can I resolve the issue