We have a custom field that is a multi-select field. It represents a report identifier. An epic can belong to more than one report, so it can have multiple values for this custom field. We have mapped it into eazyBI correctly and it works as expected. We did notice one interesting fact, when we use the the multi-select to grab a subset of members, then the results displayed are the addition of the count for each member, rather than the deduped total.
Here is an example.
Let’s call my custom field (multi-select) = “Report”, which I’m putting in the Pages dimension, with Project Category in the Rows dimension and Issues created in the COlumns dimension. When I have the “All Report” member selected, I get these counts:
Issues created
Category 1 - 5580
Category 2 - 2680
Category 3 - 2021
Category 4 - 4030
Category 5 - 2338
Total - - - - - 16649
This is the correctly deduped count of issues by category
When I de-select the “All Reports” member, and multi-select each individual Report Member, the total count I get goes up, since it is adding each individual reports count, and not deduping.
Issues created
Category 1 - 5603
Category 2 - 2977
Category 3 - 2331
Category 4 - 4569
Category 5 - 2422
Total - - - - - 17902
This count is not deduped and is higher than the total number of issues (and higher than the All Report member).
My question is, is there any way that I can specify if I want deduping to happen or is the only option to have dupes counted, if we use the multiple select tool, selecting more than 1 member?
Thanks.