I can help you with your problem but I am not able to open the Workbook as it is created with latest version. Would you please create a same issue with Tableau 8.3 so that I can have a look and Provide you the Solution
I only have installed Version 9.1 and no older Version is there a chance to make it compatible to an older version?
I have inadvertently already helped you - via the original thread
But this is more difficult...
I have tried various techniques, formulas etc. and the closest I can get is below/ attached - Its not ideal.
The month/ year values are displayed, alongside the difference, but its not easy to read/ use.
I appear also to have fixed your issue with May
I will keep trying (time permitting), I'm sure there must be a better way...
testshape.twbx 76.2 KB
thanks a lot for your answer. I rebuilt it and was wondering for what you have added the index function. It is nearly there but having the difference in a seperate row and the symbols only in the difference would be ideal
Earlier, the values from 2015 where overlaid on top of each other so you couldn't read it, so I added the INDEX() to split them out but I just removed the index, and it made no difference, so I'm not sure what I did earlier?!
Its frustratingly close, and ideally the values would be aligned differently but as yet I haven't figured a workaround.
Hoping someone may join the thread with a alternative - I would certainly be interested!!
In the meantime, I'll keep trying.
Thanks Rody, I did have a look through Jonathan's workbook already, its excellent but...
The problem is (which isn't covered in any of his examples) is having years separated into columns... that's whats causing me the issue. Everything discrete would be the closest:
but when you add the column/ year split the problems start
I really appreciate all of your help. I am just thinking loud but is it in tableau possible to maybe just hide the field if the value is blank?
I have some excel expirence and I have created there formula which shows only a field if the value is in (ifblank).Is something like this possible in Tableau?
Or is it possible to work with maybe a Zero to hide?
Ideally you'd just right click, hide column
is it in tableau possible to maybe just hide the field if the value is blank?
It is certainly possible... this was my first approach but you have to be careful which values you pick up, and therefore what you hide. The problem with hiding/ filtering 2014 is you need the values to work out the difference...
It would be something like this
IF ISNULL([Number of Records]) THEN 'HIDE' END
I tried both filtering on null differences and even tried to leverage the year in conjunction with the null difference values > so if difference was null and year was 2014 then hide. But haven't got anything working.
Its an interesting problem, but one I have yet to crack.
I'm sure it possible, that's what is most frustrating!!
I'm slightly following this thread, so if I miss-understood something, please let me know.
But I'm wondering if you would implement a Table Calc ( LOOKUP() ) to "filter" out the NULL Values after the initial Table Calc is processed.
So something like...
IF ISNULL(LOOKUP(SUM([Number of Records])),0) THEN 'HIDE' END
Where we just LOOKUP the value, and if it is NULL Hide it. The key is the LOOKUP part that forces it to be a Table Calc, thus it is filtered later in the pipeline.
If this wasn't what you were after, please let me know.
Well I already tried to hide the column. The issue I was facing not only the empty column was hide the column with the Data was gone, too
I tried with hide now but the result was nearly the same. I was not able to get rid of the empty column.
I'm slightly following this thread
All help welcome!
I have attached my copy, first sheet is Jens original (following my gide from a previous thread), 2nd sheet is my alternative attempt...
My worry with filtering, however we do it, is we need to keep the 2014 values (somehow?!) to work out the difference between 2014 vs 2015 but we dont want to display the difference for 2014 (against itself - its null), only the 2014 v 2015 difference.
I have tried every workaround, hack and trick I can think of... Sheet 2 represents the closest I can, its close but you can see the issue...
I quickly tried your formula but I think it needs some amendments...
Best of luck!!!
testshape.twbx 76.1 KB
The issue I was facing not only the empty column was hide the column with the Data was gone, too
That is exactly the issue with going down a filtering route...
The only other workaround I can think of is to duplicate the sheet and try and float 1 sheet on top of the other in a single dashboard. (overlay 2015 figures to hide the 2014 trend column) but aligning will be difficult.