Product: TIBCO Spotfire®
How to hide columns with null value during Cumulative Sum expression in a visualization.
If you want to hide the null values in the visualization while selecting the Cumulative sum aggregation for a specific column without affecting the other columns in the visualization on the Y-axis, then you can use the mention custom expression on the Y-Axis.
Example: Since there are null values for the months October, November, December in the data, so while doing Cumulative Sum for all months, instead of showing the same value as of September for the rest, we can just hide them by using the bellow expression without affecting the other selected column on the Y-Axis.
I have attached a sample analysis file to represent the same scenario named: HideBars.dxp You can make use of the following expression in the respective Y-Axis custom expression field:
Example: Avg(case when [Column Name(X)] is null THEN 0 else Sum([Column Name(X)]) OVER (AllPrevious([Axis.X])) end)
Note: Where the [Column Name(X)] represents a valid column name as per your data.