Skip to main content

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?

 

Calculated Field and/or Table disappears in stacked or side by side bar graph

20 answers
  1. May 4, 2016, 8:05 PM

    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.

     

    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.

     

    pastedImage_1.png

0/9000