6 Replies Latest reply: Nov 10, 2017 7:54 AM by Pradeep S RSS

    Count in chart

    Pradeep S

      When I give Count(OrderNumber) i get only 9 records leaving the null value in CHART whereas in Script it is showing 9 records..

       

      GIVEN IN HELP :

      Count(OrderNumber)

      10, because there are 10 fields that could have a value for OrderNumber, and all records, even empty ones, are counted.

       

       

      Temp:

      LOAD * inline [

      Customer|Product|OrderNumber|UnitSales|UnitPrice

      Astrida|AA|1|4|16

      Astrida|AA|7|10|15

      Astrida|BB|4|9|9

      Betacab|CC|6|5|10

      Betacab|AA|5|2|20

      Betacab|BB|1|25| 25

      Canutility|AA|3|8|15

      Canutility|CC|||19

      Divadip|CC|2|4|16

      Divadip|DD|3|1|25

      ] (delimiter is '|');

      what is the exact output :