Jump to content

Use Other columns rather then [Value] after THEN keyword

Michele Scarpa

Recommended Posts


I am trying to calculate the ration of cumulative sum of two columns. For one of them I have to use all values while for the other I just need the first value (This is needed as I am coloring by a hierachy) .

So I need to pick the first value and the calculate the post aggregation like:

First([Column A]) THEN Sum([Column B]) OVER (AllPrevious([Axis.X])) / Sum([Value]) OVER (AllPrevious([Axis.X]))

Unfortunately after THEN I can only use the result of firs aggregation.

Is there a way to proceed?



Link to comment
Share on other sites


basically I want to divide the value of the top graph with respect to the values on the bottom. The numerator is the cumulative sum (Sum([Value]) OVER (AllPrevious([Axis.X]))) of Failures while the denominator is the sum of unique value of System Time per each system (First([Column A]) THEN Sum([Column B]) OVER (AllPrevious([Axis.X]))). It is colored by a hierarchy (System + Component) and can be whose level can be modified by a slider. That is why I need to divide the behaviors between numerator and denominator.

image.thumb.png.af78914f1a434c365e9c8b72c526278b.pngYuo can find an sample dataset attached.


Link to comment
Share on other sites

According to the plot of which I shared the screenshot, the top par shows the cumulative sum of Failures(Sum([Value]) OVER (AllPrevious([Axis.X]))) while the bottom shows The cumulative sum of time (Sum([Column B]) OVER (AllPrevious([Axis.X])))). The time is equal for each component installed in the same system and I need to take just one of them per node.

Link to comment
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
  • Create New...