6 Replies Latest reply: Oct 30, 2011 12:16 PM by Stefan Wühl RSS

    Expression  Definition

      I have a table which contains data as follows

       

      Country,  User ID,  CardUsageCount , keyUsageCount, MMYYYY

      USA,      U12,         122,                    221                  , 042011

      USA,      U16,          0,                      500                  , 042011

      USA        U12,         60,                    122,                 ,052011

      USA       U60,           200,                 120,                 , 052011

      CANADA, C43,        22,                    340,                 ,042011

       

       

      I want to create a barchart  of CardUsers per country.

       

      So the filnal data will look like as follows

       

      Country, CardUageCount

      USA,       2 

      CANADA  1

       

      (One user U16 will be dropped as CardUsageCount=0. Since it is Distinct, U12 will be counted only once)

       

      I kept Dimension = Country

      Expression = if(  (Count ( CardUsageCount)) >= 1, Count (DISTINCT CardUsageCount))

       

       

      I am not getting the results I needed. Anything wrong with my expression?

       

       

      Thanks