Forum Discussion
percentages and multiple query columns
Wow...thanks for this! I wasn't sure how to create a table like that in a post, but it dawned on me that it could be described in the community blog post you sent me, and of course it was, so hopefully I won't make that mistake in the future.
I'm starting to see data, but I'm getting hung up a bit. First, I'm recreating the 'test', seeing that it works there before applying this to the 'real', more involved table. I've completed all the steps and this is what I've come up with:
If I unselect the "% Renting" ("Renting" in the pictures - I took out the % sign), the pie chart changes appropirately to reflect that now 50% are Returns and 50% are Owners.
Here are my issues:
- When I mouse over the pie chart as you see it here, I'm getting "Renting - 0.47 (46.67%)" when I'm hoping to see "Renting - 7 (46.67%)"
- I can't figure out how to drill down in this case. Where should the new measures for "% Rented Until Owned" & "% Early Payoff" go so that when I click on "Owners", I see a new chart showing 25% Rented Until Owned and 75% Early Payoff? I don't even see the drill down icon above the pie chart when it's selected.
I'm wondering if I've worded my overarching question wrong. I think I need to start with counts - in other words, how many total renters are there? How many Returns are there? How many Owners are there? When I put them in a pie chart, it should automatically create percentages, I would think. That way, later on I can ask other similar questions from the same counts. Hopefully I'm making sense. Thanks again for your help on this and your patience with me! I'm learning a lot!
Hi kincaids,
>>I'm getting "Renting - 0.47 (46.67%)" when I'm hoping to see "Renting - 7 (46.67%)"
The first -0.47 is round if 46.67%. "Renting - 7 (46.67%)", what's the mean of -7?
>> Where should the new measures for "% Rented Until Owned" & "% Early Payoff" go so that when I click on "Owners", I see a new chart showing 25% Rented Until Owned and 75% Early Payoff? I don't even see the drill down icon above the pie chart when it's selected.
We can create drill down in Pie Chart by select multiple fileds in Legend level. While 25% Rented Until Owned and 75% Early Payoff are calculated by measure, the measures are not able to add Legend level.
Best Regards,
Angelia
- kincaids9 years ago
Helper II
The first -0.47 is round if 46.67%. "Renting - 7 (46.67%)", what's the mean of -7?It is from the example found further up in the thread.
We can create drill down in Pie Chart by select multiple fileds in Legend level. While 25% Rented Until Owned and 75% Early Payoff are calculated by measure, the measures are not able to add Legend level.I'm not sure I'm following you here...could you expound on this? Thanks!