Date Labels in Graphs

[vikramnr]

I'm using line graph and use histogram over month to display a monthly view.

The date labels showing in the graph are not showing Monthly Dates ie. 01/12/2020, 01/11/2020 so on and so forth when selecting absolute time value in the filter. 01/09/2020 00:00:00.00 to 01/12/2020 00:00:00.000 instead having some random labels.

Is there any way we can change this behaviour? I have also noticied that it doesn't occur when we have relative time selected in the filter

[wylie (Wylie Conlon)]

The format is controlled by the Scaled Date format advanced setting, dateFormat:scaled, which determines how to display the dates based on the interval between dates. By default, any interval greater than 1 day will show the full day, and there is no interval that shows the month label. You can change this by adding something like ["P28DT", "YYYY-MM"], or ["P28DT", "MMMM"],

[vikramnr]

Thanks @wylie . So doing so will affect all other dates displayed in other graphs where we use data histogram for days,weeks etc.,?

[wylie (Wylie Conlon)]

That's right. We are tracking a feature request to add custom date formatters to the Lens editor as well as the more general request to add custom formatters to Visualize

[vikramnr]

It would be a great feature if implemented. Thanks for the help @wylie .