Months on X-axes with week accuracy

[#1]

Hej

I want to represent revenues over a year with months on the horizontal axis but the curve is smoothened compared to when I uses weeks on the same axis.

My datasource is a timestamp so I wrote in my script:

Directory;
LOAD
Date as Date,
Year(Date) As Year,
Month(Date) As Month,
Week(Date) As Week,
Day(Date) as Day,

I would like to have the curve I get when I use week but with the month caption on the axis.

Thank you for your help.

[juleshartley]

There are a few ways that you could achieve this I think. If you simply use the 'date' field on the x axis then you can format it as Date([Date],'MMM-YY') for example... but maintain the detail in the chart

[er_mohit]

Try to conctenate like below in edit script

Week(Date) & ' ' & Month(Date) as Weekmonth

[antoinelaviron]

Hi,

In your chart, in dimension used, use the following calculated dimension:

     Dual( if(     Mod(Month,4)=0,     Month,     null()

                    )

             ,Week

             )

Values of the week will be used in the drawing of the chart but this is the value of the corresponding month that will be displayed on the axis.

if(Mod(Month,4)=0, Month,null())

is used to reduce the number of values of a same month displayed on the axis but I would sugest you to use a flag in your script.

Best,

A.

[#5 · Accepted solution]

Thank you for all your answers.

Unfortunately none on them really worked exactly.

What worked finally was using Dual(Month, Week) as a dimension and then sorting by ascending numerical value.

Best regards,