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

    Set analysis not bringing through data



      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)