0 Replies Latest reply: Mar 20, 2014 4:55 AM by Jorge Trillo Rios RSS

    Table simple .. count(min(week) where week is not a dimension

    Jorge Trillo Rios

      good morning,

      to see if you can help me,  please

      I have a set of items with a delivery date of order,  In the script I calculate the load weekname both dates.

       

      item order date w_od_name delivery date w_dd_name
      101/01/20142014/0101/01/20142014/01
      303/01/20142014/0101/01/20142014/01
      305/01/20142014/0101/01/20142014/01
      507/01/20142014/0201/01/20142014/01
      511/01/20142014/0201/01/20142014/01
      104/01/20142014/0106/01/20142014/02
      202/01/20142014/0106/01/20142014/02
      406/01/20142014/0206/01/20142014/02
      410/01/20142014/0208/01/20142014/02
      318/01/20142014/0308/01/20142014/02
      219/01/20142014/0329/01/20142014/05

       

      the goal is to represent the number of different items that are delivered in the MIN w_od_name, being requested a w_dd_name as dimension. I get

       

      w_od_name MinString(w_dd_name) count(if(w_dd_name=MinString(total w_dd_name),item))
      2014/01 5
      2014/012014/013
      2014/022014/012
      2014/032014/020

       

      I get to set the number of items for the lowest week of the document but not the dimension

      please,, help me

       

      thanks and regards