4 Replies Latest reply: Oct 31, 2012 9:48 AM by Roberto Maglieri RSS

    Setting a table to COUNT different dimensions

      Hi all, sorry to bother you but i started last weekend to use QV.

       

      I have different excel sheets that i use as source and all the data are connected.

      I imported them into QV and started to make a dashboard.

       

       

      CUSTOMERSERVICE
      Aservice1
      Aservice2
      Bservice2
      Cservice3
      Dservice1

       

       

      SERVICEACTIVITY
      service1activity1
      service1activity2
      service1activity3
      service2activity1
      service3activity2
      service3activity3

       

       

      Now i would like to COUNT how many DISTINCT Customer, how many DISTINCT services and how many DISTINCT activities are there and foinally put them in a table.

      Kind like this:

       

      DIMENSIONCOUNTER
      # Customers4
      # Services3
      # Activities3

       

      I also would like this stats to remain fixed while i select and analyse the rest.

      Actually i created 3 different text box with the expression " = COUNT (DISTINCT Customer) " but the number inside changes to 1 as i start to select and analyse the data.

       

      Do i need to create 3 variables to store the counters? How and where i can do that?

       

      Help meeeeeeee!!!

       

      Thanks and have a nice day