topic Re: A way to show a date with no data in graph builder in Discussions

A way to show a date with no data in graph builder

shampton82 — Fri, 23 Feb 2024 23:42:53 GMT

Hye everyone,

I have a chart where I'd like to show each day and if there is no data for the day the date would still show but be blank.

Here you can see that there is no data for the 22nd. However, I would like that date to still show up. I'm thinking I might have to use JSL to check that there is a day for ach day possible between the min and max dates in the data set and add in a dummy line item for any missing days but interested if anyone else has a different approach I could take.

Thanks for any ideas!

Steve

Re: A way to show a date with no data in graph builder

hogi — Sat, 24 Feb 2024 14:58:52 GMT

You could add some dummy rows - with dates, but with Freq set to 0 or missing.

dt = New Table( "test",
	Add Rows( 20 ),
	New Column( "date",
		Format( "d/m/y h:m:s", 22, 0 ),
		Formula( Today() + In Days( Row() ) )
	),
	New Column( "freq",
		Set each value(if (contains({5,6,7}, row()), . , 1) )
	)
);

dt << Graph Builder(
	Variables( X( :date ), Frequency( :freq ) ),
	Elements( Bar( X) )
)

Re: A way to show a date with no data in graph builder

jthi — Sun, 25 Feb 2024 15:00:55 GMT

Is your END_DATE properly formatted as a date (numeric and continuous)? Usually Graph builder will "force" you to show all dates if you have set your column as numeric continuous

Re: A way to show a date with no data in graph builder

dlehman1 — Mon, 26 Feb 2024 12:43:17 GMT

Now that I can once again log into the Community (as an aside, I will yet again rail against this 2 step authorization - it has made it harder to participate, and when it fails like it did this weekend, it makes it impossible - please go back to the old log in):

I think the question is whether you have the date with the missing data in your data set or not. If the date is there but the data is missing, then I think if you change the data type to nominal, it will display with the data missing as you want. If the date is not presently in the dataset (meaning that there is no data but also no row for that particular day), then I think jthi's solution will work.

Re: A way to show a date with no data in graph builder

shampton82 — Mon, 26 Feb 2024 16:00:48 GMT

I agree the two step is a step backwards!

In this case it was that there was no data for the date, and the suggestion from @jthi worked. I have had times where I want the data to be Nominal and in that case you have to add in dummy data along the lines of what @hogi suggested.