Yes, but that shows all records... in other words, I see the records for Metric 1 and the records for Metric 2.
I can get this to work for one Metric by used number records. However, something finicky is happening when I try to use COUNTD.
Looking at it more closely I would expect you would see all the records in the group for each metric. This is happening because no records are being filtered out of the data source. COUNTD is just counting the distinct names.
You'll have to find a way to filter out any duplicate records and records with Term = NULL, you may need to split the metrics into 2 worksheets, one with the row headers and metric 1 and another without row headers and metric 2.
Thanks for the thoughts. I played with this a bit more...
- All Metrics are a Type so I put Type on the columns shelf. My group of leaders stayed on the rows shelf.
- I need counts for each Type to be independent because I need to add a few together, subtract a few from each other. So I made a record count for each type.
IF [Type] = "Metric 1" THEN [Number of Records] END
- I applied this calc - now I'm able to see the the total counts and I'm able to drill into the data for each Metric and Person.
However, I can't combine a few of those custom calcs and display them on the columns shelf.
I think the count method is the best way to go, but really need to be able to drill into the data. Any thoughts?