Jump to content

Cumulative value y-expression and line from Column Values

Diane Seidel

Recommended Posts

It seems that it would not be that hard to plot an aggregate y-value expression and also a line from a column value on the same line chart. However, I cannot get this expression to work unless I change the X axis to "categorical". A continuous axis cannot access Axis.X for some reason.

Percentile([Norm Oil],50) THEN Sum([Value]) OVER (AllPrevious([Axis.X])) as [Cum P50 Oil]

When I change the X axis to categorical, my line from column value disappears, and I get the message "The X-axis is categorical. Line from column values cannot draw curves over categorical axes."

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