1 Reply Latest reply on Oct 6, 2014 12:47 PM by Charles Frenzel

    Custom SQL Count () function inflated

    Charles Frenzel

      I am having an issue with the following custom sql :

       

      Select  ID, Category, Count(Category) as cnt

      From table

      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.

       

      Likewise,

       

      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.