Distinct Count Requirement

Product suggestions
16

Hi @Riasat

In principle this looks good. My observations:

  1. The count menu item, I think the measure types (sum, count) should be seperated to make the menu less cluttered. I.e.:
    image
  2. This is count, what about count distinct?
    I.e. number of ship tos at customer level could be 20, but thats 20 invoices, in actual fact there are only 5 ship to locations, so rather than seeing 20, we would want to see 5.
    Another example, take number of parts customer has ordered, a count would show say 200 (invoice lines), but its actually only 7 parts they have purchased across the date range.

Therefore the above screenshot should be:

image

Does this make sense?

Regards,

Jon