Well, file this under “just because you can doesn’t mean you should.” Search the forums on parsing strings with Tableau and you’ll find a lot of guidance which pretty much says “don’t do it!” and “better to do it in your source!” These people are undoubtedly right. But, what if your source is an existing […]
SSRS: Parse parameters column from ExecutionLog
Ever worked on a quick little project, come across what you assume is a common need and think “I’ll just google up some code that someone else has written and then be off to the races”? Have you done this and not been able to find the code you’re looking for? Well, that was me […]
Tableau + Git: Ignore default directories and preference files.
Here’s a quick little item you might find handy. If you find it annoying that git keeps showing some of your default Tableau directories and files (which would probably only happen if you change your Tableau default repository) then you can set git to exclude those files and directories when it checks for modifications. In […]
Tableau: Format Date As String mm/dd/yyyy hh:mm
gah. Why is some of this stuff so challenging in Tableau? You have a date and you want to format it as a string? Why? So you can concatenate it with another string perhaps? Maybe you’re creating a calculated field to use in a label (that’s what I was doing). Unfortunately, when you convert a […]
Tableau: Custom Date Range Picker
For Tableau requirements like: Allow user to choose “Last 7 Days”, “Last 30 Days”, etc. this is your ticket. It turns out one parameter and one calculated field are all you need.