Data connected to Tableau generates transactions that show 2 sets of timestamps. RFID Reading Time = time that an RFID tag was read to indicate inventory is low AND replenishment completion time = time that inventory was replenished.
The data can have 2 transactions for a single piece of inventory because there is more than 1 RFID tag associated with each inventory item (One Tag = P another Tag = S). P Tag = halfway point of inventory and S tag = full inventory used. For example - if a P tag is read by RFID - this sends a signal to replenish 50% stock. If a S tag is read - this sends signal to replenish 100% of stock.
The problem: if BOTH P and S tags are read - this creates two identical transactions. However, one of those 2 transactions is replenished. Need help to eliminate the transaction that generates Null data for Replenishment completion time and KEEP transaction that generates Time stamp for Null replenishment time. Must do so without excluding other transaction lines that generate a Null value but only have 1 transaction line. Please see example data attached.
23 freelancer đang chào giá trung bình $112 cho công việc này
Hello, I would be happy to work on this matter, starting immediately. I am available via chat here, let me know if you would like to work together! kindest regards Raly
I have been working for a major bank as data analyst using Tableau Desktop, Server and Prep. I have experience in handling data calculation as what you have stated here. Fee is negotiable.
The tasks looks good and deliverable in quick time , with my year experience and vast knowledge in data science . I am certified in tableau ,will certainly meet your expectation.