Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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!
Do you get an error message or just blank?
return " - " in the KPI variable I created.
You can add certainly, And before moving can you check Hour as filter and Count(DISTINCT Numero_OrdenVenta) in text object. Then, Do filter on Hour and check whether the values are changing or not.
Hi
I did, the values does not change. Well in this case I can understand the Hour(CalendarTime.Field) does not have any relation with Hora_Procesado(FactTable.Field). In case I use Hora_Procesado as Filter it´s Works. My problems is that I have 2 hours to compare with the filter. this is the reason I can not use the Hora_Procesado as Filter.