Hi all,
I'm creating a demographics dashboard. the first view is a simple Gender breakdown, by count:
The second view is a geographical map:
The functionality I'd like is to click on Female in the first dash, and update the geographical map to display a calculated field Female Percentage:
COUNT(IF [Gender]='Female' THEN [Gender] ELSE NULL END) / Count([Gender])
Likewise, when I click on Male, the geographic map should update to display Male Percentage:
COUNT(IF [Gender]='Male' THEN [Gender] ELSE NULL END) / Count([Gender])
I've tried to do this via another calculated field, Percentage Switch - Gender:
if ATTR([Gender]) = 'Male' then [Male Percentage]
elseif ATTR([Gender]) = 'Female' then [Female Percentage] END
But, as you might have guessed, this doesn't work, because it filters down to only male or female values, and shows all percentages as 100%. Is there any way to accomplish this functionality, preferably without parameters? Sample workbook attached.
Makes perfect sense. Here's what we're looking at for a solution: 5 calculated fields is all we're gonna need. I've annotated each calculation to explain what they all do.
Let me know if this is what you're looking for! I put together a combined dashboard as well, although you're action filter still works to switch from the Breakdown to the Map.