Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hi
I have a table with hudred thousands lines structured as below
DATE CAR REF MOVE
01.01.2022 RNTX1 Entered
08.03.2022 RNTX1 Entered
15.08.2021 RNTX2 Get Out
22.02.2022 RNTX1 Get Out
20.02.2022 RNTX1 Fixed
....
There is dates from 01.01.2018 till today
There is a incalculable number of CAR REFERENCE
There is 3 possible MOVES : Entered / Fixed / Get Out
My goal is to create a table based on dates like below knowing that the CAR REF is doing the rount trip hundered times
CAR REF ENTERED FIXED GET OUT
RNTX1 01.01.2022 20.02.2022 22.02.2022
RNTX2 ..... .... ....
.... ..... .... ....
RNTX1 .... .... ....
.....
Based on your request, it appears all you need to do is create a matrix visualization with the data and ensure that your data model is connected correctly. Without more information about what you are exactly trying to create though I don't know if we can help you more than that.
User | Count |
---|---|
98 | |
90 | |
78 | |
72 | |
65 |
User | Count |
---|---|
114 | |
98 | |
96 | |
68 | |
67 |