Dashboards & Analytics Discussions
cancel
Showing results for 
Search instead for 
Did you mean: 

Forum Posts

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

DaveS by Rocketeer
  • 262 Views
  • 1 replies
  • 0 kudos

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

DaveS by Rocketeer
  • 190 Views
  • 0 replies
  • 0 kudos