Tableau Dynamic Linked Parameters

2011-11-26T11:15:53+00:00 November 26th, 2011|Tableau|

The first thing to tell you is this isn’t possible, one of the few weaknesses in Tableau. I wanted to set up 2 parameters in Tableau, the first would be a start date, the second an end date. What I wanted to do should be straightforward – to set the values available in the end [...]

Quickest way to remove the time from a datetime in SQL

2018-05-07T20:22:07+00:00 November 10th, 2011|SQL|

In an earlier post I showed some ways to remove the time portion from a date, but the obvious follow on from that is which is fastest. To test I ran both versions on a dataset of 1.9m rows of data. The DATE datatype returned the records in 15m 35s = 935s Getting the data [...]