9 Replies Latest reply: Feb 12, 2015 9:20 AM by Simone Spanio RSS

    Set analysis not bringing through data

    Andre Toerien

      Hi

       

      I have an issue with set analysis

      I have cloned charts one uses this expression and it is working fine

       

      count(distinct(if(MeterType = 'K' and ExpectedConsumption = 0 ,UnitNo)))

       

      The other chart I have the following set analysis, the syntax seems to be OK but it is just giving me no data to display

       

      Count(distinct{$<MeterType = {"K"} , ExpectedConsumption = {0} > } UnitNo)

       

      What am I doing wrong. the value in ExpectedConsumption  comes from SQL where it is a numeric(5,3)