Tableau Add Comments to Calculated Field

2020-05-31T11:05:00+00:00May 28th, 2011|Tableau|

In Tableau, while creating calculated fields, the inevitable question is how to add comments to a calculated field in Tableau. Comments are simple to put into a calculated field. Just start a line in the calculated field with two forward slashes // Everything typed after the // on the same line is a comment. Adding [...]

SQL First Day of Month

2020-03-07T17:05:33+00:00May 19th, 2011|SQL|

This post describes how to find the first day of a month in SQL. The code is: DATEADD(mm,DATEDIFF(mm,0,DateToRemoveTime),0) A full explanation of how this works is in a previous post describing how to remove the time portion of a datetime in SQL. This is exactly the same except use the month (mm) instead of day.

Tableau Format Month

2020-03-07T10:00:08+00:00May 18th, 2011|Tableau|

Often space is limited on a dashboard so you need to save as much as possible. One place where Tableau wastes a lot of space is with displaying months. On a line chart showing with months on the X axis Tableau displays the full month name  – i.e. January, February…December. This takes up a lot [...]