My sincere apologies if this question has been dealt with elsewhere, but I am unable to locate a concrete answer. The specific issue that I seem to be having is with the proper way to visualize a calculated field and/or table in a comparative bar chart. In this case I am attempting to show the percentage of the total population of Puerto Rico that is Low Income. So I began with two SUM measures and one dimension. Using the "Create Calculated Field" I have converted the SUM Low Income Population Total to a percentage. However, when I go to illustrate it in a stacked or side by side bar graph I can't seem to get it to show up anywhere. What am I doing wrong or what else needs to be done to create an accurate viz?
Hi Phil,
You've got the dual axis so you are pretty close. Try switching the Mark Type of LOW Income % to Square or circle.
and/or edit your secondary(rightmost) axis and set the range to fixed and the fixed end to 1.