I am having an issue with the following custom sql :
Select ID, Category, Count(Category) as cnt
Where <my parameters here>
Group by ID, Category
I then take it into tableau and try to sum the counts but they are coming up as double or triple what they actually should be.
I confirmed in the view and the data looks fine. They are inflated.
I have tried using simply a select without the countd on category with a non-group by query it goes red and I am unable to display.
Please advise on the solution to this.
Figured out a workaround after a couple of hours.
the answer was here :
Re: Writing SQL in Tableau vs connecting to a table
Select Analysis > Aggregate
Become a Viz Whiz on the Forums!
Support the Community and master Tableau.
Retrieving data ...