4 Replies Latest reply: Oct 14, 2015 7:23 AM by Kristof Jacobs RSS

    TOTAL doesn't work on caclutated if dimension

    Kristof Jacobs

      I have data about the usage of transportation by day.

      I wanted to make a slider where you could select a day and see which clients already used that kind of transportation.

      With a TOTAL I could make percentages by transportation.

       

      There is also a calculated dimension that divides the clients in 2 categories: 'used it' or 'didn't use it'.

      No problem so far.

      But when I wanted the make the calculated dimension I bit more relevant it doesn't work anymore. I used an if to make more categories like: 'bought a ticket', 'no ticket', 'used', 'not used' ...

       

      Anyone a suggestion how to solve this?