Find Jobs
Hire Freelancers

Write me a Tableau calculated field to do a moving hourly sum

$10-30 AUD

Closed
Posted almost 4 years ago

$10-30 AUD

Paid on delivery
I have airport data where each row is a departure flight showing its departure date, departure time, number of seats on the flight and the airport the flight is departing from. I wish to create a new column called "Rolling Hour Seats" I need to sum the seats of all flights departing in the next hour for each flight and airport. I'm guessing i need to use a "{fixed [orig] : " to separate the Airports (Orig). For example, a flight has a departure time of 9:10am on the 2/04/2018 at airport AAA; i want to sum the seats of all the flights departing AAA from 9:10am on the 2/04/2018 to 10:09am on the 2/04/2018 (exactly 60 minutes from and including the departure time of the flight in question) I want to do this without using a window calc I also want to use this calculation to determine two factors, shown in the excel file attached I have attached two files: 1. "Peak Hour Data" - the input data 2. "Peak hour Data - Example Calc" - shows the two calculations that need to be done for each flight, as well as the three outputs i wish to create in a table like the one in the document. I have also attached a photo showing the calculation to get the Datetime
Project ID: 25891419

About the project

20 proposals
Remote project
Active 4 yrs ago

Looking to make some money?

Benefits of bidding on Freelancer

Set your budget and timeframe
Get paid for your work
Outline your proposal
It's free to sign up and bid on jobs
20 freelancers are bidding on average $44 AUD for this job
User Avatar
Hi I am a very experienced statistician, data scientist and academic writer. I have completed several PhD level thesis projects involving advanced statistical analysis of data. I have worked with data from several companies and have done projects involving high level quantitative analysis and data interpretation skills to study the trends, time behaviour and compare the variables in the data. I can do advanced level analysis in SPSS, R, PYTHON, WEKA, TABLEAU, POWER BI, and EXCEL tools like machine learning, deep learning, AI, NLP, hypothesis testing, forecasting, T-test, ANOVA etc. Looking forward to discussion, Best Regards, Suyash
$250 AUD in 7 days
5.0 (2 reviews)
3.6
3.6
User Avatar
I have seen your requirement which is quite interesting..will help you out, feel free to reach me any time.
$19 AUD in 3 days
4.9 (4 reviews)
1.5
1.5
User Avatar
I have 3 yrs of experience providing end-to-end BI solutions for a large video game company in California. I regularly build tableau dashboards for use by c level executives. Hence, I can offer excellent quality with a quick turnaround time. This would be a great opportunity for me to build my repo on this platform.
$35 AUD in 7 days
0.0 (0 reviews)
0.0
0.0
User Avatar
Hello, I saw your requirement and I want to ask you whether we need to show only aggregation of seats of next coming hour and it should refresh every time when we opened the dashboard right? I can able to help you with the calculations on these. Please let me know if we can able to work on this. About myself, I am Nithin and working as Tableau developer since 4 years. I have good knowledge on advanced concepts. Thanks, Nithin
$25 AUD in 1 day
0.0 (0 reviews)
0.0
0.0
User Avatar
I have strong experience on tabluea Relevant Skills and Experience Skills- tabluea
$25 AUD in 1 day
0.0 (0 reviews)
0.0
0.0
User Avatar
Dear Recruiter, I have been working as a Business Intelligence Consultant from around 10 years and have very good experience and expertise in designing and building analysis, dashboards and stories using tableau. I have gone though the details you have shared about the required output. I have strong command in creating LOD calculations in tableau besides my expertise in data analysis and Visualisations. I am sure I would definitely provide you the required output within the timeframe. Looking forward to hearing from you. Regards Anil
$67 AUD in 3 days
0.0 (0 reviews)
0.0
0.0
User Avatar
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 analytics project execution which involves the following taks: a) Data Management (Processing, Cleaning, Transfomation) b) Data Reporting/Dashboarding (BI) c) Data Analysis/Modeling To accomplish the above mentioned tasks, I am extensively using the following tools: - SAS - SPSS - R - Python - Power BI - Tableau - SQL - MS Excel - MS Access
$56 AUD in 1 day
0.0 (0 reviews)
0.0
0.0
User Avatar
I will be able to solve it by lod expression. I have 4.7 years of experience in tableau. I have good understanding of date calculation as well.
$20 AUD in 2 days
0.0 (0 reviews)
0.0
0.0
User Avatar
Two calculated fields can be used for calculating the rolling sum. I want to give it a try. Don’t pay me if not done.
$20 AUD in 1 day
0.0 (0 reviews)
0.0
0.0
User Avatar
Hello, I am a professional Analyst turned freelance Tableau developer /BI Analyst ,having multiple reporting experience for deriving insights and telling stories . Have worked with few large BFSI projects for the same . I/My Team can help you do the same for the data you provided . Do let me know if you want to proceed . Thanx/Aman
$15 AUD in 5 days
0.0 (0 reviews)
0.0
0.0
User Avatar
Will complete the project within time limit
$25 AUD in 1 day
0.0 (0 reviews)
0.0
0.0
User Avatar
Hi, I am a BI Consultant with 9.5 years of experience in reporting using Excel, MicroStrategy, Tableau, Power BI and SSRS. I can help you with the project. Regards, Purushottam
$30 AUD in 1 day
0.0 (0 reviews)
0.0
0.0
User Avatar
Hello, I do have 6+ years of experience with Tableau working for an insurance company here in the USA. You are correct that you will probably need a LOD calc to get a rolling total. I can probably work on this for you later this evening US time, or tomorrow. But is there a reason you don't want to use a window calc for this? Though the LOD will be like {Fixed [Orig], [Dep TIme] : Sum([Dep Rolling Hour Seats])} If you want it to say 9:00-9:59 - 100 seats 10:00-10:59 - 200 seats I can think of a few ways to do it. I would have to mock it up myself in Tableau and get back to you. Please do message me. if you have questions. Thanks, Scott
$30 AUD in 7 days
0.0 (0 reviews)
0.0
0.0

About the client

Flag of AUSTRALIA
Melbourne, Australia
5.0
1
Payment method verified
Member since May 21, 2020

Client Verification

Thanks! We’ve emailed you a link to claim your free credit.
Something went wrong while sending your email. Please try again.
Registered Users Total Jobs Posted
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Loading preview
Permission granted for Geolocation.
Your login session has expired and you have been logged out. Please log in again.