If you need to do lots of customized calculation on metrics, wide is easier. You can grab each measure to the calculation right away.
If you want more flexible VIZ, ie. a filter to select metrix category(ies), long gives you that option easily.
1 of 1 people found this helpful
To answer your second question, additional years are added before and after your data because Year is currently set as a Continuous field in the view. Tableau will display Continuous fields on an Axis.
One option is to right-click the axis and select a fixed range from 2007 to 2014.
Another option is to right-click Year on Columns and select Discrete to remove the additional years values from the view. In this case you may need to re-set the Mark type to Line.
More information about the differences between Discrete and Continuous fields can be found here:
Let me know if this helps!
Sarah, this helped about why Tableau adds on one additional year, but why -one- additional year on each end, why not two or three, or zero? I did end up editing the axis manually.
Sarah, thanks for the link to Tableau and "normalized" data. It looks like it just says it's just because tableau decided they want it that way. I can't really tell why. But thanks.