13 Replies Latest reply: Nov 6, 2017 12:03 AM by Maria Gonzalez RSS

    Count Orders specific Hour selected

    Maria Gonzalez

      Hello,

       

      I need to count the orders Delivery and Processed in specific selected Hours. I have no idea if I need to create calendar time and link direct to fact table. I already have the Delivery_Hour field and Processed_Hour field into Fact table.


      Count(

           {$

                <Date={"$(=Date(max(Date),'DD/MM/YYYY'))"}, _Id_Flag={0},Estatus_Cobranza= {'EN SURTIDO','FACTURADO','ENTREGADO','CONSOLIDADO'}, Liberado={1}, TipoDeEntrega -= {'SOLO FACTURA'}

           }

           distinct Numero_OrdenVenta)

       

       

      How I can add the Hour selection into my set analysis ?

       

      Thank you!