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

    Count Orders specific Hour selected

    Maria Gonzalez



      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.



                <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!