I'm using the following tables in my report:
and my calculated field looks like:
IF [Parameter] = 1 THEN SUM([turnover])
ELSE [Parameter] = 2 THEN AVG([turnover])
I need the sum/avg (turnover) of contacts clicked in "Category1 and Category2", the expected result are:
sum=441 and avg=147
but i've got:
sum=517 and avg=129,25
Has anyone any idea how should i avoid the turnover (76) to be counted twice?
Thanks in advance!
See this link: Removing Duplicated Data after Joining Tables | Tableau Software
I'm attaching a very simple example of a dataset using data blending to avoid duplicated records.
Become a Viz Whiz on the Forums!
Support the Community and master Tableau.
Retrieving data ...