Hi all,
Student working on a project where we're trying to calculate ratios based on 3-years worth of industry information. As it stands, our professor understands that calculating the true ratio in Tableau isn't something a beginner would be able to accomplish, but I'd like to learn how it can be done. So thanks in advance for any assistance in solving this.
For example: We require the Return on Equity (Net Income / Avg. Equity). To calculate the average equity, we'd sum the previous year with the current year. As it stands, the professor is fine with the calculation (Net Income of 2015 / Equity of 2015). To take a step further, it's requested that we use the medians of each industry to calculate the ratio as it'll be less influenced by outliers.
I've created a calculated field in the prior worksheet which calculates the profit margin as an example. From reading some other discussions, I'm thinking I need to have the 2014 and 2015 information available? I'm drawing a blank there though.
Hi, Chris
Not very sure what's your expected result,is it something like this?
build the average value of two years for each industry, and add as reference line
Workbook attached.
Hope this helps
ZZ
