1 of 1 people found this helpful
The technique in the link you provided is a good one we used frequently prior to Tableau 9.0. The better technique now is to use Level of Detail (LoD) calculations. There are many sources of info on LoD calcs, one is http://www.tableau.com/sites/default/files/media/whitepaper_lod_eng_0.pdf.
However, neither technique will solve your problem if Tableau does not have access to the underlying data. If the data source is filtering it before Tableau gets it, it is impossible for Tableau to perform any calculations on data that it doesn't have access to.
That leaves you with these options:
- Change the data source so it gives you all of the data, and do the filtering based on the user in the viz, and use LoD calcs for the averages you are desiring.
- Create a secondary data source which calls the underlying source in a way that gives you the averages you want without filtering based on the user. This might take the form of a view or stored procedure which returns only the aggregated values, not the secured data. Then you can show that data in another pane in a dashboard.
Sorry if that doesn't help, but you are limited to the data available to you.
Thank you Bill. I will surely take a look at it. LoD also is not of much help here. Already tried using it.