So yes FIXED LoDs are the way to go here...
Assuming that your TOTAL surface is the total of everything in your data the formula would be
This way the first part is at the VizLoD and is sensitive to any filters, but the last part is always the total surface area of the entire data-set (regardless of 'regular' filtering).
If that doesn't do the trick, it would be really useful to see a "mock up" of the data...
Nice to hear from you (especially with comments like that ...I noticed your activity gradually re-ramping up over the last few weeks!!
Yes if the required filtering is single select, then Parameters are a good solution here (always lots of ways in Tableau!!)
@victor- apologies for hijacking the thread...
As mentioned to Shawn earlier, I have been around, just mainly moderation only (self imposed), I was starting things i couldnt finish (just too much going on!) and felt that wasnt fair on contributors.
I have/had a slither of time and missed getting involved so tried to help on a few threads. I hope to keep it up, but it will be at a reduced level for now.
And i stand by my previous comments, i admire your work, style of delivery and just everything!
i sincerely hope the next intake of zen masters corrects last year's 'oversight'... hint...Tracy Fitzgerald
Thanks for your replies. I don't only have one filter but many. So in this calculation, both numerator and denominator need to be affected by all filters except for 2 filters which musn't affect the denominator.
I attached a simple example of how my data is structured and some filters I need to use. In this example, I want both numerator and denominator to be affected by the city filter but only the numerator to be also sensitive to the category and rent/sell ones.
By the way, @deepak, I am not able to open your workbook (maybe about the tableau version? I'm in 10.1 version, can't upgrade it yet to 10.2).
KPI_Buildings_Example.twbx 11.8 KB
So in order to do this we just need to bump the City filter up the Calculation Pipeline! (this, btw, is why FIXED LoDs aren't affected by regular filters, as they are calculated before any regular filter is applied, but by making the filter a "context" filter, it now affects both the LoD part and the regular aggregate part)
In the attached I've changed your KPI to (we don't need City in there as this is handled by the context filter on City)
SUM([Available surface]) /
and also brought the LoD part on the Labels, so you can see that it is affected by the City filter, but not by the other 2
Let me know if that isn't doing what you want
KPI_Buildings_Example.twbx 12.2 KB
I think that's it!! It seem it fits my needs. I'll apply this concepts to my real dashboard and hope to make it correctly works. If any doubts I'll come back!
Many thanks to all.