1 Reply Latest reply on Jan 19, 2017 8:36 AM by Tom W

    Want to count entries of higher grade of detail [ver 10.1]

    Jürgen Minwegen

      Hello, I am fairly new to Tableau. I have two pictures. The first one shows me the correct Number of counted entries. But when I add another dimension the result changes. Why does it work like that and how do I prevent it from happening.

      Link1: http://imgur.com/a/PtaSm (correct) Link2: http://imgur.com/a/qDQ5f (count changes)

      I tried it with {FIXED [E] : COUNT([Q])} but this counts all Q-entries with the same E altough A is different and does not change when I change the filter.

      I think this is something pretty basic to solve and I managed to do it with qlik and powerBI but right now I am kind of idealess.

      This is what it should look like:  Imgur: The most awesome images on the Internet

        • 1. Re: Want to count entries of higher grade of detail [ver 10.1]
          Tom W

          When you count E with the Q dimension on the shelf, the dimensionality is changed. So in this top slice for example your count of E is four, but as soon as you introduce the Q dimension the count changes because there's 1 'E' record per 'Q'.

           

           

           

          You're close, you just need to change your FIXED calculation to this;

          SUM({FIXED [A],[E] : COUNTD([Q])})

           

          Because you aren't just fixing it at E level, you need to fix it at A combined with E