Month repeated in a line chart

[Bellamy]

Hello,

I can't figure it out why this is happening, probably a really banal question, but I could not find a solution.

I have a date expressed in MM/YYYY. The original date was a timestamp (with hh:mm:ss TT all like this '12:00:00 PM') and I converted in only MM/YYYY using Date(Monthstart(Field),'MM/YYYY').

When I show the data, in some case, I can see the month repeated on the chart many times, even if the data field contains only the begin of the month (for example 01/2022 and if I check with a time stamp it gives me 01/01/2022 12:00:00 PM).

Is it a "visualization bug" or is it a problem related with the date format?

In the case of the picture, if I reduce the cart in a smaller size, the bug disappear.. But in other case bug persist because there are few months to show and it repeats the same label many times

In the value field I am using a set analysis like this:
Sum({$<MonthDiff={"<12"}, AsOfMonth={">$(varMaxDate_rolling_chart)"}>} QT_ORDERED) / 12

Thank you in advance 

[anthonyj]

Hi @Bellamy ,

The line chart has a continuous axis. What happens when you turn the continuous axis off or visualise in a bar chart. Is the duplication still present?

If it's the underlying data not converting correctly maybe it would benefit from a more explicit reading of the timestamp (A little long winded):

date(monthstart(floor(date#(Field, 'DD/MM/YYYY hh:mm:ss TT'))),'MM/YYYY')

Thanks

Anthony

[Bellamy]

Hello Anthony, if I try with a bar chart, then the problem disappear ... 
So , do you think it's only a graphic "bug" ?

Also, if I turn off "continuos" the data start to be sorted in a random way..

About the date format I have also to say few words: in the script area at the beginning I settled 
SET DateFormat='MM/YYYY';

Then in the script in which I upload a table that has a date in the format 'MM/DD/YYYY hh:mm:ss TT' I write this :

date(monthstart(DATE_FIELD)) , since the date format I settled before.

Also, I do sum of the values of the table and group by the same date(monthstart(DATE_FIELD)) in order to "ignore" all the days of the date_field but just aggregate and sum it. Is it correct this approach? Or is it here something wrong?

[anthonyj]

Hey,
A good way to settle the question is to add a table object to your sheet and build the visualization from there. You can debug by adding the dimension and your measures. If there's a duplication of the dimension in your dimension row then this would indicate a difference in the underlying value of the dimension. You could diagnose this by adding the dimension again like this. NUM(Date Field). This would expose the underlying value that could be causing the duplication.

If there is no duplication in the table then I would say it's to do with the visualization. The continuous axis is made to expand and contract depending on the amount of data you're viewing.

Regards

Anthony