-
1. Re: LoD - Aggregate Pairs of People and Aggregate those Pairs by # of Categories Paired on - TWBX
Charlie Archer May 17, 2016 9:42 AM (in response to K. Marie)Hi Marie,
I have had a look through this and think that i may have created the required view by using the following LOD calc:
{FIXED [Left Person], [Right Person]: COUNTD([Category])}
This calculation is stating that, for each matching pair, i want to calculate the number of categories matched.
To create the buckets that you mentioned, i have simply converted the LOD calculation to Discrete (right click on the measure in the data pane and select 'Convert to discrete'.
Now when i add this new, discrete, LOD calc to rows, and COUNTD(Left Person) to columns i have a bar chart showing the number of (unique) people that have matched with someone else across 1, 2, 3, and 4 categories.
Hope this makes sense (and answers your question!).
Thanks,
Charlie -
2. Re: LoD - Aggregate Pairs of People and Aggregate those Pairs by # of Categories Paired on - TWBX
K. Marie May 17, 2016 10:20 AM (in response to Charlie Archer)Hi, This is helpful. I'm wondering if you could help me with something else now?
I built the view, but it is showing like this:
If a person has 4 matches, it shows 4 marks on the bar on the 4 matches bar. I want that person to show as 1 mark on the bar. Is there a way to group them again?
I tried a nested LoD, but It's not working.
Thank you again.
-
3. Re: LoD - Aggregate Pairs of People and Aggregate those Pairs by # of Categories Paired on - TWBX
Charlie Archer May 18, 2016 1:02 AM (in response to K. Marie)Hi there,
I'm not sure if i understand - maybe it would be useful to show the stage that i'm at.
I have a bar chart showing the unique number of people with 1, 2, 3 and 4 matches. When a single 'left' person matches 1 category with multiple 'right' people, they are only counted once in this chart.
Was this what you meant by the above?
Thanks,
Charlie -
4. Re: LoD - Aggregate Pairs of People and Aggregate those Pairs by # of Categories Paired on - TWBX
Charlie Archer May 18, 2016 1:03 AM (in response to Charlie Archer)Workbook didn't properly attach to last message...