I've just started to use Tableau and am looking for a little help. I'm not sure if what I'm trying to do is possible.
I have a worksheet with Control Charts displaying yield numbers for 5 separate machines (depending on which is selected). The average (and other ref. lines) is calculated -
WINDOW_AVG(SUM([KG Machine - Row]))
[KG Machine - Row] is connected to a parameter.
This works perfectly, but i want to expand this -
I now have a new sheet which has the same parameter (same 5 machines). This sheet will chart Overall Yield ([KG Machine - Overall]). In order to get the Average line and all the other lines I can create new calculated fields. I'll also have to do the same with another two yield type calculations. I'll do that for now, but I'm hoping there's a tidier solution.
Is it possible to use a single Average Line calculated field to calculate the averages for different measures across multiple sheets?
What you are asking should be possible, and you really shouldn't even need to create a bunch of calculated fields and parameters, but a lot depends on the structure of your data. Can you attach a packaged workbook? If you have confidential data, please see Anonymize your Tableau Package Data for Sharing |Tableau Support Community.