Unit Conversions as a Dashboard Filter
Hey, there!
I have several business requirements for multiple dashboards to include a "toggle" of sorts between different unit conversions -- most often it's currency, temperature, and ft2/m2, and ...
Forum Discussion
I had the vague idea that this *must* have been handled before, and I found this post from the old forums that Sisense Support has been kind enough to preserve as documentation. I believe it shows how you could use a conversion factor as a multiplier and then set the dashboard filter to one of the conversions. If I understand it correctly (I haven't had time to experiment), if the user disabled the filter it would set the values to 0 or maybe even N/a.
Thanks for sharing that link -- bookmarked!! It explains way better than I could what my dashboard and model are currently doing. I received feedback from a client recently that showed that when the filter is disabled (they did not realize it had been disabled), the calc conversion values are all added together. I had hoped the result would have been N/A, but I guess it makes sense as the formula is written.
I'm looking for a way to lock the filter so that it is always turned on and the user cannot disable it, forcing a filter selection. I guess the title of my original post is a little misleading now that I think about it -- sorry about that.
I think the example does things slightly differently from the approach you showed in your post. You sum all the converted values. The article instead defines the conversion factor as a single multiplier. It uses the average, but you could also use Min or Max to get a default value. When the filter is disabled in this case, the multiplier is still a single value
So something like SUM([BUILDING], [TotalCost])*MAX(Conversionfactor)
I guess for that also you should also only have a single costs column, and not a costEUR, costGBP, and costUSD columns as you now appear to have
When it comes to forcing a filter selection without locking the filter. Hmm. If you are in a position to hide the regular dashboard filters, you can consider adding a filter through Blox or the old Community Filter Widget and disable the 'No Selection' options there.
It's an interesting challenge to be sure!
