-
1. Re: How to calculate ratios
Matt LuttonAug 27, 2014 7:31 AM (in response to Robert Larity)
This does make it difficult (your data structure). I'd recommend reshaping your data, such that you have individual measures for each.
How to Shape Your Data | Tableau Public
Hope this helps. Reshaping can be accomplished in the data source, via Custom SQL in Tableau, or through various ETL/reshaping tools.
-
2. Re: How to calculate ratios
Robert Larity Aug 27, 2014 7:54 AM (in response to Matt Lutton)Thanks Matthew. My data is actually shaped like the "Normalized Data" example shown on the link you provided (i.e. the example showing the "right" way to do it).
If we were to take that example (i.e. the one provided at the link, with net income for different companies), I'm basically trying to calculate a ratio of (Citi Group's Net income) divided by (General Electric's Net Income).
It seems like I need to change my data structure, so that "Nominal GDP" is a column header/label, is that correct?
Many thanks-
-
3. Re: How to calculate ratios
Matt LuttonAug 27, 2014 8:16 AM (in response to Robert Larity)
Yes, that would make this a bit easier. Those articles are a bit confusing, I agree with that -- Unless I'm mistaken, I don't believe your data is normalized in the way that Tableau would like. What I think would make this much simpler is if Nominal GDP was its own column in the data source, as well as "Consumer Credit", "Debt Outstanding", etc. with Dimension values for things like "Sector", "Credit Type", etc.
I'm not an expert on this--perhaps Aaron Clancy can provide some more specific guidance here.