-
1. Re: Totals dont work when secondary DS has LOD expressions.
David Li Nov 23, 2016 6:00 AM (in response to gabriela..zorrilla)Hi Gabriel, do you have the option of combining all three data sources into one data source?
-
2. Re: Totals dont work when secondary DS has LOD expressions.
gabriela..zorrilla Nov 23, 2016 6:07 AM (in response to David Li)I can (and i'm doing right now) modify one of the datasources (Oracle DB) to avoid having to use a LOD in Tableau, but is annoying.
Merging the three DS is out of question, sadly.
-
3. Re: Totals dont work when secondary DS has LOD expressions.
David Li Nov 23, 2016 6:12 AM (in response to gabriela..zorrilla)Yeah, that's probably your best bet. I don't think you can reference LOD in secondary data sources.
-
4. Re: Totals dont work when secondary DS has LOD expressions.
Joshua Milligan Nov 23, 2016 11:04 AM (in response to gabriela..zorrilla)I think the main issue is that you can't use an INCLUDE or EXCLUDE LoD in a secondary source (because those depend on the view level of detail which is determined by the primary data source). But you can use a FIXED LoD.
So, if Supplier and Check Number give you a unique check then you should be able to use a FIXED level of detail in the secondary:
{ FIXED [Supplier], [Check Number]:
max([Check Amount])
}
One thing that might keep this from working is if you are using secondary source dimensions as filters. Since you are creating a scaffold, you should be able to build a scaffold data source that allows for all filtering using only primary fields.
Hope that helps!
Joshua
-
5. Re: Totals dont work when secondary DS has LOD expressions.
gabriela..zorrilla Nov 23, 2016 11:28 AM (in response to Joshua Milligan)Hi Joshua,
Thanks for your tips. But i believe because my Fixed LOD loads more than one row this is not working. I had to create a custom view in Oracle get just the totals of every check, with no duplicated rows at all. After that, this works.