-
1. Re: Calculated field giving error.
Simon RuncJun 15, 2018 3:59 AM (in response to Amit M)
1 of 1 people found this helpfulhi Amit,
So the problem here is the BCG calculation, which is an Aggregate (MAX). So as an aggregate works over the level of detail of the Viz, Tableau can't combine row level (all the other parts of your calculation) with this aggregation, as it doesn't know what the MAX is of.
If you let me know at what level the MAX is over? (eg. if it was patients, and they might have several entries, and you want to take the MAX over their entries) I can give you an LoD version, which gets returned at row level, so can be used in this calculation.
-
2. Re: Calculated field giving error.
Jim DehnerJun 15, 2018 4:04 AM (in response to Amit M)
1 of 1 people found this helpfulGood morning
without seeing the data I can only guess which field it aggregated but you have something that you BCG, Next Visit Date, Or Date of Birth that is an aggregate - probably from a previous calculation - and remember - min(), Max() are also aggregates - you can wrap the other variables (the ones not aggregated in Attr(), Min() or max() whichever works best in your analysis
Jim
If this posts assists in resolving the question, please mark it helpful or as the 'correct answer' if it resolves the question. This will help other users find the same answer/resolution. Thank you.
-
3. Re: Calculated field giving error.
Amit M Jun 15, 2018 4:14 AM (in response to Simon Runc)Hi Jim,
Thank you for your explanation and quick response. Your example is similar to what i am trying to achieve using max function with BCG calculated field. Request you to please share the LoD version of BCG so that I would replace it with my current calculation of BCG and intern it would fix this calculation as well.
I am newbie on tableau. Appreciated your help on this.
Thanks,
Amit
-
4. Re: Calculated field giving error.
Jim DehnerJun 15, 2018 4:27 AM (in response to Amit M)
Good morning
Sorry
you will need to share more information -
suggest you review the readings at