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.
I have a database that collects multiple rows of data for projects over time. Some columns such as Hours Worked (shown below) change over time, others such as Revenue Estimate do not but are duplicated in every row. I am trying to write a formula to generate a new field showing the accurate Revenue Estimate at the project level of detail (Revenue LOD). I cannot remove duplicates within the data because Hours Worked is charted over time. Below is a chart showing an example of the data and the desired calculated field output. Thanks!
Hi - I would like to have a new field in the same table so that I can use a conditional formula to select the estimates based on the current stage. Similar to using the fixed field in Tableau if you are familiar.
That makes sense. Is there an easier way to accomplish this using a formula? The calculated field that I am trying to recreate in Tableau is below. The fixed function in Tableau is similar to the Summarize function in Alteryx. Thanks for the help!
Assuming all of the fields listed in this LOD exist in your Alteryx workflow, you could use the entire IF function in Alteryx with only a few small syntax changes to create a new field in a formula.
Then you could use a Summarize tool to summarize by Project Title, which I think is the best way to accommodate this type of calculation. This would give you a line by line set of cost savings in one field which you could easily total or select a MAX from.
I guess average would not be suitable to use in this case, as in project "A", we have revenue estimate of 75 at the "end" stage which has then been considered in the final desired output. MAX can be used instead of AVG in my opinion.