This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
Good Afternoon,
My team has been working on a problem for quite sometime now using a large data set, but after numerous attempts but no success of developing results quickly we put together an example in excel. There are 2 data sources attached which include test cost information and unit information. The excel sheet attached also includes those sheets, but our desired outcomes are in the sheet named "Results" and the calculations are behind those results are in the sheet "Calculations".
Our issue is that the costs are at a Cost Type level while our units are at a higher level.
There are 3 different desired outcomes...
1) Unit Cost by Cost Type and Company and Month
Essentially each line should just be the total cost for that cost type for that month, by the total units for the month.
2) Unit Cost by Company and Month
The same as 1, but cost type is taken out of the equation, this is a sum of the costs for a whole month by company divided by total units for that month.
3) Year to Date Unit Cost by Cost Type and Company
Just a sum of the total costs by cost type regardless of month, divided by the sum of all the units for each month.
If anyone could help us solve our problem in Alteryx we would be so appreciative, because our real data source is over 50,000,000 lines of data.
Thank you,
Justin
Solved! Go to Solution.
The first two are perfect, thank you. For the last one though we want the units to be the same for each cost type under the distinct company, I think I know how to do that, but the bigger challenge would be showing how unit cost actually changes month over month from the year to date calculation.
Thank you!
A Multi-Row Formula Tool is a good place to start working on Month over Month, Year over Year and YTD formulas. I'll take a look if / when I get a chance
Iain
Sounds good, thank you!
How do you combine these different outputs and bring them to one table for Tableau presentation?
See Append Fields tool for one approach. Output to TDE