Hi, You may try a column/line combination chart, fill the line part and use a calculated constant null key figure for the (mandatory) column part. Null values are handled differently in combination chart lines comparing to pure line charts. Hope that helps. Best regards, Philipp
------------------------------
Philipp Hornung
------------------------------
Original Message:
Sent: Fri April 29, 2022 09:46 AM
From: Jonathan McKnight
Subject: Line visualization (11.1) still shows null values
I want to use a line visualization in a report, but I'm getting an unusual result and I can't figure out how to change it. The visualization shows actual and projected amounts with nulls where actuals are on or past the current day and projected is null when it is a past day. The vis comes out like this with the null values showing as 0. Does anyone know how to make the null values not show on the visualization?
------------------------------
Jonathan McKnight
5x IBM Champion
Business Intelligence Analyst
Nashville, TN
www.linkedin.com/in/jonathanmcknight
------------------------------
#CognosAnalyticswithWatson