3 Replies Latest reply: Mar 10, 2017 10:32 AM by Leo Harper RSS

    count function in kpi

    Leo Harper

      Hi all,

       

      Apologies for the noobness of the questions...but...I have loaded the following sample data. I'd like to use a KPI to show how many of the 5 lines of data are underperforming, on target and over performing

       

      data:
      load * Inline [
      sample, actual, target
      sample1,1,3
      sample2,3,3
      sample3,4,3
      sample4,1,5
      sample5,3,3

      ];

       

      the expression I would use is along the lines of

       

      count(actual<target)     for under performing

      count(actual=target)     for on target

      count(actual>target)     for over performing

       

      what is the correct syntax for these queries please???

       

      thanks,

       

      Pokes