Specify X tick marks as both category and specified?

[uma bhattParticipant]

Dear Consultants,

I am trying to make a graph with dates on the x axis for some of 183 days. I used Categories in X tick marks and then a Date data column where I removed the dates I did not want to show up. But then I can not specify the tick marks I want and all 183 show up as the same size. I would like major tick marks a the start and middle of the month and minor ticks or none in between. I am sure there is a smarter way to do this but I could not figure it out or find in the FAQ or in the documentation. I am attaching a screenshot.

Regards,

Uma

[dgteamModerator]

Here is an example with custom date axis labels.

The locations are set by selecting “Labels” in the Axis settings.

The year, month, and day are generated using Expression columns.

These are then combined into the Days column using a seconds(year, month, day) function where the Type is set to “Date”.  You could combine it into one expression but we left it separate for clarity.

The Labels column is created using a Mask column.

Does this help?

[uma bhattParticipant]

Thanks so much for the quick response. I think I understand and will give it a try!

 

[Author]

Posts