DATE CALCULATION

Hi everyone :

I am stuck in trying to generate a final view just like "view.xlsx" which is basically a graphic overview of date calculation, this model is to calculate the total attendance of a whole fleet by counting all the day that one unit was either shipped, in transit or returning to the origin point.

I was able to make the general template but unfortunately I can not move forward to complete the 1 or 0 logic.

Could you help me?

Erick Castillo

VIEW.xlsx

CALENDARIO.xlsx

ALTERYX.xlsx

asistencia.yxmd

Date Time

Accepted answers

Raj

i have generated logic according to my understanding and optained required result

kindly go through it and make required changes

please let me know in case of any help

asistencia.yxmd

heitenfrozten

This report allows me to support the accomplishment level in units (Trucks) allocated to my customer by counting either the shipments made by date and the units in transit.....

All comments

Qiu

@heitenfrozten
Can you kindly elaborate the meaning of 1 or 0?

Raj

why have you joined by position

I don't feel any logic in it

Raj

i have generated logic according to my understanding and optained required result

kindly go through it and make required changes

please let me know in case of any help

asistencia.yxmd

heitenfrozten

1 is a check that the unit (Trcuk) is in transit outbount or inbound

heitenfrozten

This report allows me to support the accomplishment level in units (Trucks) allocated to my customer by counting either the shipments made by date and the units in transit.....

heitenfrozten

thnk you for helping me,,, this is what I was looking for

Quick Links

This months top contributors

AkimasaKajitani 389

mceleavey 388

mbarone 337

michael_weaver 335

Hollingsworth 335