Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hi all, I wonder if someone can please assist.
I have ship visits, and I'm trying to calculate the hours difference between when a ship arrives at anchor (MoveType = Arrive at Anchor) and is assigned a berth (MoveType = Arrival). So I'm wanting to create a separate table viz that rolls up to show one Duration for each visit to measure how long the ship spent at Anchor (the first date when MoveType = Arrive at Anchor) until it was assigned a berth (the last date when MoveType = Arrival)
A few notes:
- Each ship has a unique VisitId.
- There are other MoveTypes, but I only want these two to be included in the calculation.
- I have active date and cargo type filters used on the page
Here is what the table viz looks like as is:
Thanks in advance!
Solved! Go to Solution.
@Anonymous ,
You may refer to the following post.
@Anonymous ,
You may refer to the following post.
Thank you so much! Perfect. Amended it to fit an existing column that contains an Id field (VisitId), and it works perfectly.
User | Count |
---|---|
98 | |
89 | |
82 | |
70 | |
67 |
User | Count |
---|---|
114 | |
104 | |
101 | |
72 | |
65 |