Vizlib line chart shows false data point after most recent month (circled).

[Kranty]

Vizlib line chart shows false data point after most recent month (circled). That false data point should not be there. After the current month reflecting extra wrong data point. Could you please resolve the issue

[stevedark · Accepted solution]

Hi @Kranty 

That data point is for all values where the date is null (missing).

There should be an option on the Month dimension in the properties where you can exclude nulls.

Alternatively, you can excluded them from the expression using set analysis:
sum({<Month*={*}>}Value)

Or, you can stamp a different month in the load script:

LOAD
   Date(if(isnull(Month), MonthStart(today()), Month), 'MMM-YYYY') as Month,
   etc.

Hope that helps.

Steve

[Kranty]

Thank you Steve. It worked