1 of 1 people found this helpful
Hi there! As far as I know, Tableau generally converts calculated fields into parts of PostgreSQL queries to use against its internal database. So the SQL should optimize IF...ELSE statements and other statements. This can get pretty complicated, but in general, I'd expect that calculated fields that result in row-level values will be precomputed and stored in Tableau's working context table. That can result in substantial front-loaded processing, so you may need to send it higher upstream for processing if Desktop starts slowing down because of it.
As far as performance goes, I'd recommend following best practices and not worrying too much about the rest. For instance:
Thanks David. It helped. I do not have access to edit the data sources. It is a Tableau Server Data source.
I have done few things like hide fields, lesser dimensions, easier Calculations to make dashboards perform better.
Still it takes 10-30 seconds for each changes on parameter/Filters.
But one concept came in where there should be a long If-else statements in a Calculated field. I couldn't really avoid it.
it's gonna be 10-50 elseif statements, that's why I am concerned about the performance.
Lets hope it goes well. Awaiting more replies from other Experts too.