Hi - your formula did not aggregate properly - see the forumla below
it returned this
I am on a different version of tableau and you would not be able to open the workbook
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.
Thanks Deepak. Creating a calculation with average fuction resolved my problem. The constraint with real time data was not as simple as mock data which i posted here , i was using LOD calculation and was adding a parameter value along with that. This method ie., using a separate cal field for avg resolved the proble.