Am I winning or am I losing?

You will need a cup of tea for this, sit tight.

OK, so I had thought I would give the #WorkoutWednesday a go even though I feel completely out of my depth. I have already been watching Twitter seeing everyone’s tweets about the tool tips and LoD calcs so at least I am mentally prepared for the battle that is about to begin. Have I mentioned LoD calcs give me nightmares; I have been in dire need of using it but have not yet. I’m told I will need a use case for them, I understand the theory but not the practice – so let us hope today is a winner.


To start with, @Andre sent me the data in an Excel file; I plugged it in to Tableau to get a ton of years and was like what, this is not right. SO already, I went in and stole the data set from other workbooks so it is neatly laid out ready to go. I started with copying what was easily identifiable from the screen shot to my X and Y-axis (see above). You can tell it is a date field on the top, so I added the year and then used every measure to match the Y-axis. And no luck 😦

I left that and moved on to something else, in Andy’s instructions he mention you need to select a different stat – so that I knew was a parameter – dropped down his selection and wrote out the text in my parameter.


You already know with every parameter comes a calc so I knew that was my next step; an IF statement – I know some people have IF arguments, this worked for me and I knew it. #Winning number 1


After this I became a bit stuck, and unfortunately had to download the workbook and have a look, I didn’t want to completely undo myself I wanted to try and work it out from at least the measures before opening up the pills and seeing what made them. The first one was 25th Percentile – I was stumped, what does that even mean? Went to my trusty friend Google to get some answers and figured it was the 25% mark out of the 100% – but that was wrong too so I had to open the pill and look to re learn and figure out. Darn.

Next the pill Stat. So I knew this one – it is the calc we just made for our stats selection and that was showing the Median – if in doubt right click and hey presto it was there! #Winning number 2

It turned out as below, after I put the axis to dual – even my parameter was working #winning number 3.


So, what do I do now, why does Andy have his years on the top and long bars and a different number layout on the Y-Axis, what is this wizardry? Made a dual axis, sync’d it – again hey presto I had years on the top. #Winning number 4

I noticed there was a 75th Percentile – I mean I just did this one so surely it is the same calc but with 75? I tried it and it said our favourite message appearing ‘this calculation is valid’ yeessss #Winning number 5 I was pretty chuffed – did not know what it meant but it works, who cares. (Jokes I did care). I dropped that on the size marks card and we have lines, fat long chunky lines. #Winning number 6!

Then QBs in range – I saw this was on the tool tip card, I already knew people had trouble with the tool tips and I had heard there would be a LoD calc – holey moly I opened it and there it was in its glory. Let us just take a second, what? I get the idea yes I really do – but how to create that off my own back – no chance.


I played around with many of the features and tried to figure out some more of the calcs. The 75th TD was interesting, as I guessed it was using a different measure and noticed TD by luck – so duplicated all the calcs that needed TD (from AK’s viz) changed the measure to TD and they all worked. #Winning number 7 – I then had to rename a few of them measures to understand it more in my head, instead of saying TD this and TD that I edited the alias and would repeat the actions saying Touchdown this and Touchdown that… It works for me– if I see it how it is meant to do without shortcuts, I may remember it more.

Lessons learnt – what did I learn today? Well percentiles to start with, I mean so simple yet so complex. Then LoD calcs – let us not even go there, I think I have a fear! Thanks to @Andre at the end for explaining, I needed to turn my year into decimals – who knew? Although my X-Axis did not fancy the change clearly because it is still wrong.

Also to tick ‘none’ on the X-Axis for your tick marks to hide the years – sneaky. As well, I went over some calcs in the main viz and noticed a CASE Statement used – I used an IF Statement, why would they be different? Therefore, I took this moment to do some research to learn about the differences, concluded over developer preference…That could be wrong. Now I can use both – I am taking that as #winning number 8

I also learned I should be a little more confident in my work and findings because you do know, and you will figure it out and it is ok to cheat. It is better to cheat a little and learn new things then to cheat a lot and learn nothing.

So thanks Andy K – this one is for you.


P.S. This might look like a fail attempt but I really tried, and actually learnt a lot from failing. What doesn’t knock you down builds you up – come at me next week!!/




I’m Just Like You…

Welcome, it’s my first Blog – if you couldn’t tell. I wanted to share my experiences and help others to grow, learn and develop.

So I started off with Tableau like a deer in the headlights as everyone else probably did, I still don’t even understand everything I am doing but its great, it gives me challenges everyday and keeps me involved. However, you know what the best thing is to do – trial and error! I have learnt not to be afraid of testing this theory, or figuring it out thinking “well if that doesn’t work, try this” until you find the solution you are aiming for. If I do figure it out, I tend to make a note of it, and carry my Tableau bible everywhere with me. No one expects you or me to remember everything.

With Tableau, you can explore so many different areas, and the community is the best to get new ideas from and share experiences or even troubleshoot some problems as well as sharing frustrations. We all have that moment when Tableau does not work, or tableau is having a slight meltdown or you’re having that meltdown in a data rabbit hole.

I wanted to start blogging after inspiration from a pool of other data friends out there, after reading their blogs and sitting back watching all the data madness I believed it was time that I too would join the crowd, I’m sure I even dream about what I am going to say in my blog post – and here we are!

So let’s start with my first #MakeOverMonday I kept this simple and followed the lines of a bar chart – we all know bar charts inside out. I always feel like sometimes I should push the realms of possibility but then I end up creating a bar chart and hey presto it makes sense without all the tricks. If you’ve come across @ChrisLuv you’d know he uses the KISS method  – ‘Keep It Simple Silly’ or stupid which ever you prefer. 😀

It does the job, it tells you women are paid significantly lower than what men do in Australia, I have even put a filter on occupation so you can select above the bar chart. Then followed by a percentage of gender types in that particular work place. What more do you need?

You can make a quick snap shot decision based on a simple visualisation without the headache of figuring out what is what. #MakeOverMonday – reason No.212 (exaggerated a little there) why it is a good weekly challenge to learn from. A simple bar chart, yes, but you can derive more questions from it to go build on whether on your viz or more vizzes! So here you can go away and ask yourself, why do Women get paid less? Is it the education system? Is it the job system? Is it because women are more likely to stay at home? Who knows – but lots to dig deeper from a simple bar chart. Yay.




Create a website or blog at

Up ↑