Can't we just separate the columns for 2014 and 2015 and create a difference between the 2 fields to eliminate the need for nulls and lookup?
If different years are needed just create a float parameter to change the years of interest.
Create 3 separate axes for the 3 calcs, place 2014 calc on the 1st axis, 2015 on the 2nd and difference (with additional formatting on 3rd). Place calculation 2 on shapes for the 3rd axis:
Calculation 2 = IF sum() - sum() > 0 THEN 'Up' ELSEIF sum() - sum() < 0 THEN 'Down' END
V9.1......I need to upgrade LOL!
Sorry I can't open this to help out further.
But I'll re-read through thread and see if I can figure something out at a glance.
Pooja, any reason why you don't start earlier, and leave me to struggle?!?
Your intervention was very helpful... and gratefully received.
I had to amend the formulas/ cards a little but your hint was what we needed.
@Jens, Sheet3 of the attached.
I have hard coded the years, although as Pooja mentions you could use parameters.
The last thing is headers on top, you can try and follow Jonathan's guide that Rody passed us earlier.
I hope that's more suitable now
testshape.twbx 86.9 KB
Rody, just wanted to mention that I have 8.2, 9.0 & 9.1 all installed. You could do the same (unless it's against company policy). Just remember that the last one you install will be the default, so in your case install 9.0 last.
I followed you approach and I must say its a cool way of solving the problem. I am able to create a replica of the sheet but I am struck with one approach .Would you please throw some light how I gonna achieve this. In your image , Arrow Signs are appearing after the numeric digit but in my case it is appearing before the numeric digit. Have you done any custom formatting on last column.?
I am glad you found it useful. Click on the 'label' button on the 3rd axis and change the alignment to 'left'.
Wow. Its worked perfectly /Now I can use in my Viz.Dont Know how I missed this.
Appreciate your quick input on this.Thanks Pooja
This is a great thread! Ton's of useful workarounds and attached is one more. Below is where I learned it from.
I feel the link above explains everything that's going on in the workbook, but if you have any questions do post them!
EDIT: version 9.1
testshape 194908gv.twbx 128.0 KB
Good morning everybody,
I have never thought this thread will be so interesting not only for me
I really like the idea to hardcode the years and a way how this can work BUT () what you will miss then is the flexibility if you want to show in a presentation additional years.
This would be the ideal solution
P.S. Is there a chance to get the years on the top instead of the bottom?
This a very nice approach .Mr Rody Zakovich mentioned the similar approach in one of his
So how do we get the Up/Down KPI Indicator? Well this is actually a feature of Tableau that isn't well documented, but Tableau supports ASCII Shapes. So to get the Up/Down ASCII Shape, just hop on over to this Wiki page and copy/paste the shapes you want into the Format
Thanks for bringing this approach . It was a clever way of solving the issue.
You can display additional years by using a parameter instead of hard coding the years within the calculated field. You can also just use MAX(year) incase you want to show the latest year in the data set. For your 2nd question above having headers on top, you can simply place each of the 3 calculated field next to the axis it belongs to on columns as shown below. Click on the little arrow of the pills you placed on columns and make them dual axis. Then click on each of the marks card that get created and get rid of the color of the marks by making the transparency 0%. Finally right click on the bottom axis and click format and change the color of the title to white so that they are not visible. Hope this helps.
Thanks Shawn Wallwork I didn't know that.
I have 9.1 installed on my personal computer, but haven't gotten the chance to upgrade us at work yet (I might just wait till 9.2).
But this is great to keep in mind!