Bar/line View: Custom date range with no value endpoint?

carlosmartinmari · May 6, 2015 4:29AM

Hi,

I'm trying to show a plot from data starting in January, but I don't find the way to set a custom plot range, since it coincides that in that specific month we don't have any data point value.

Any way to make that plot to start from Jan-2014?

Is there a way to work that through?

Thanks,

paola · May 6, 2015 7:16AM

You could insert a date 'place-holder', so record with date 1/1/2014, and leave the value field empty.
Under the Measures menu in the Bar/line view, click on the sub-menu for the specific line measure and choose the option 'Break line', so January date will be visible on the X axis, while the null value measure will not be connected with other values.

carlosmartinmari · May 6, 2015 10:09AM

The measurement is the number of records... Is there any way I can put a null record that is not counted?

paola · May 6, 2015 10:11AM

Sure:
RECORDCOUNT -1

Welcome!

Categories

Ideas Parade

Tagged