topic Vizlib line chart shows false data point after most recent month (circled). in App Development

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

Kranty — Mon, 13 Jun 2022 04:25:00 GMT

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

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

stevedark — Mon, 13 Jun 2022 07:55:44 GMT

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

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

Kranty — Tue, 14 Jun 2022 12:18:47 GMT

Thank you Steve. It worked