Tableau Formula Help

Zaprto Objavljeno pred 3 letoma/leti Plačilo ob prevzemu
Zaprto Plačilo ob prevzemu

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.

Tableau

ID projekta: #26378806

Več o projektu

21 predlogov Oddaljen projekt Aktiven pred 3 letoma/leti

21 freelancerjev ponuja v povprečju za $112 na tem delu

rutvikparmar

I am Data Scientist with 4 years of experience in machine learning and statistical analysis of data. I am very well experienced in using R and Python for data modelling and prediction. Reporting technologies like Tabl Več

$122 USD v 1 dnevu
(5 ocen)
3.8
kelvinm094

Hey I am a professional data scientist with 5 years of experience. I hold an MSC and first Degree in Economics and statistics which provides me with the necessary background to handle your project. I have skills in Ta Več

$100 USD v 1 dnevu
(3 ocen)
2.9
Valuesolutions

Hello, I have briefly read the description on yourTableau-Formula-Help project , and I can deliver as per the requirements however I need us to discuss for more clarity on the details, deadline and budget as well. I Več

$140 USD v 7 dneh
(3 ocen)
3.4
ajaybansal1995

Hi, I am a data analyst with expertise in tableau and advance excel. I have experience of creating interactive dashboards and LOD calculations. I have understood your problem and can help you with that. Lets connect Več

$50 USD v 7 dneh
(3 ocen)
0.9
sumarajesh

 Certified tableau professional Over 10 years of IT experience with 6 BI tool design, and development of reports, Dashboards using Tableau 10.X.  Created Rich dashboards using Tableau Desktop and prepared user storie Več

$140 USD v 7 dneh
(0 ocen)
0.0
vsachinn

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.

$80 USD v 1 dnevu
(0 ocen)
0.0
Sunitav36

I am intrested in this project and i am ready to do it for you.I have 8+ Years of experience in Excel, i can make any reports with Automation, Web Search,data cleaning , data extract, Visualization Dashboards in excel Več

$30 USD v 1 dnevu
(1 Ocena)
0.0
muralivedula

I work for ITC Limited and my main Job is to build tools or analyse the data coming from 20 different factories. Vba & Macros is one of the tools I use along with Tableau & R. We can sit on a weekend and sort out the i Več

$30 USD v 2 dneh
(0 ocen)
0.0
contactdataframe

Hi, I have a total 13+ yrs of experience working in Data analytics and data science. I have complete numerous projects in Tableau. Happy to chat more. Thanks, Harsh

$250 USD v 7 dneh
(0 ocen)
0.0
nikhilgupta84

Data Scientist/Analytics Consultant with over 13 years of industry experience. I have worked in various domains like Retail, Banking, Insurance and Healthcare (Real World evidence). I have been invoved into end-to-end Več

$139 USD v 1 dnevu
(0 ocen)
0.0
Jamal1132

I am profession BI Data Analyst lead having experience around 7 years. Worked in practical projects for Different industries like Aviation, Airline, Healthcare and Banking. So I can deliver this within less than a wee Več

$140 USD v 7 dneh
(0 ocen)
0.0
rohit897145

Hii i Will going to complete this... Plz text me for further discussion Relevant Skills and Experience Skills- tabluea

$56 USD v 3 dneh
(0 ocen)
0.0
speedinsure

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.

$140 USD v 3 dneh
(0 ocen)
0.0
rdakova

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

$36 USD v 1 dnevu
(0 ocen)
0.0
radsfreelancer

Hello, I am a professional database and reports developer. I have worked in IT industry for over 10 yeas now. I have just thrown some numbers in this bid as I do not know your exact requirement. I would be happy to ta Več

$50 USD v 7 dneh
(0 ocen)
0.0