Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi guys,
I'm creating a new dashboard and I need please your help because I'm stuck..
I have a table structured as this:
SHIP. ID STATUS DATE OF THE STATUS
001 PICKED UP 2019-01-01
001 DELIVERED 2019-01-05
002 .........
If I add one table to my dashboard to count number of days between start and delivery with Networkdays, it works, but I'm stuck when i need to creare a KPI to say, for example, that I have 80% of deliveries within 2 days.
This is the formula that works for each shipment:
=NetWorkDays( only({<Tracking={'PICKED UP'}>} TrackingDate), only({<Tracking={'DELIVERED'}>} TrackingDate))
But if I add a Count function before it, for example, or Sum function, I get an error: Nested aggregation not allowed.
Do you have any idea for that?
Thank you very much again!
why you dont try with cross table load