BGS Session 7 – Special Calculations – Date Functions
Dates are a very special class of Dimension – I mean real dates – not a string (text) that looks like a date or is
Jim Dehner
Tableau Visionary and Ambassador
Tableau How to’s, Use Cases, and Forums Questions
"Beyond Getting Started … A Path to Understanding Tableau" follows the journey I took when I first started using Tableau. I was lost – With an Engineering and Marketing background, I could not understand how Tableau worked. – Sound familiar? I needed to understand how Tableau worked in my own language before I could even try making simple text charts or graphs – and don't even think about an IronViz-level dashboard.
I did that and a few years ago I wrote a series called “Zero to Zen” about the 5 fundamentals I needed to learn. Some of you, actually many of you, used the series. A lot has changed since then indeed! So, it is time to revisit the topic with this new series Beyond Getting Started (BGS). It is intended for new and experienced users who want to get to the next level – everyone is welcome.
First and foremost, Tableau is not a spreadsheet calculator. That is obvious yet for newbies there is a tendency to try to translate code rather than understand how Tableau works. Have you ever tried to learn a second or third language? In the beginning, you try to translate verbatim into the new language (everyone does it). Only with practice do you learn to think in the new language – That’s when it becomes easier.
Download Tableau workbook at BGS Workbook
Dates are a very special class of Dimension – I mean real dates – not a string (text) that looks like a date or is
Session 8 – Custom Calculations Special Topic LOD Expressions Level of Detail (LOD) expressions are unique to Tableau. Earlier we talked about the grain (the
Want to total across the row or column, rank a dimension, or pick out a single value? Then you need a Table Calculation! But how?
Filters are easy to use, but why are they so often a source of confusion? (see the video Link to Filter Video There a 6
Do you use sets? If not why not? Sets are not like Groups or Filters: Sets categorize your entire data set into 2 segments –
For new and more advanced users, alike Parameters are misunderstood and misapplied! Parameters are a function that allows the user to manually input a single