-
1. Re: LOD / Table Calc - need help (Tableau 10.3)
Joe OppeltSep 15, 2017 1:06 PM (in response to Christopher Antony)
1 of 1 people found this helpfulYup. [Violations Count] is an aggregate. And that's because components of it are aggregates.
You can do FIXED calcs to change the components to row-level measures instead of aggregates.
-
2. Re: LOD / Table Calc - need help (Tableau 10.3)
Joe OppeltSep 15, 2017 1:25 PM (in response to Joe Oppelt)
In the attached I changed [Weekly Average Hours] to a FIXED LOD. Notice that on the Measure Values shelf your original calc goes on as an AGG, but mine goes on as a SUM. To get there I made a FIXED calc for number of hours by clerk and rotation as well so I could use it in the new Weekly Average calc.
Do that for all the other calcs that make up [Violations Count]. Once you've done that, then you'll make a similar FIXED calc to replace [Violations Count] so that you can then use that in the % complaint calc.It helps when you are creating these to make a sheet like I have here so that you can be sure your calc is resulting in the correct value. Once you have it right, you're off and running, and you can delete the debugging sheet.
-
CHristophers example.twbx 155.6 KB
-
-
3. Re: LOD / Table Calc - need help (Tableau 10.3)
Joe OppeltSep 15, 2017 1:27 PM (in response to Joe Oppelt)
1 of 1 people found this helpfulAnd, if you want, as a final step, you can actually nest all those calcs (or at least most of them) into one giant calc. I personally like to leave the interim calcs compartmentalized for easier debugging 18 months from now. ("What the **** did I do here??") But you will find others who prefer one calc. It's a matter of style.
-
4. Re: LOD / Table Calc - need help (Tableau 10.3)
Christopher Antony Sep 18, 2017 9:13 AM (in response to Joe Oppelt)Joe,
This fixed my issue! It took me a while to figure out. As you mentioned I went back and changed all the calcs to LODs. It worked.
Thanks for your help.
Chris