Folks,
In any time series chart, it looks like Tableau defaults to the first day of the month on the tick marks.
Is there a way for Tableau to show the last day of the month instead?
You can sort of force it by going into "Edit Axis", starting it on a month end, and 1 as the monthly interval. However, this is not a dynamic process and would require that I update this every time I had new data.
Anyone have any ideas? Thank you!
Yan,
What you describe seems to be the default behavior of axis, as tick-marks default to something like DATETRUNC('month', [<your date field>]).
You could calculate and make a date truncation towards the end of the month with a calc filed like this:
dateadd('day',-1,dateadd('month',1,DATETRUNC('month', [<your date field>])))
This you can place as "Exact date" on your columns shelf, and it will be visible in the tooltip, however axis tick marks will still be with the beginning of each month by default unless you make the date pill discrete.
Hope this helps,
Vlad
