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

Forum Posts

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

Formatting Transposed Data

Im using transpose to take this long list of measures to rows. However, i cant figure out to add color to the transposed columns. In the second screen shot only the measures are highlighted but that isnt highlighting the transposed columns. Simply pu...

Adetweiler_0-1720812465700.png Adetweiler_1-1720812689765.png

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
  • 29 Views
  • 0 replies
  • 0 kudos

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
  • 35 Views
  • 0 replies
  • 0 kudos