

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
How do I get an average from a Count Distinct?
I need to get the average for this expression, but it gives me an error that nested aggregation is not allowed:
=COUNT(DISTINCT([Driver ID]))
How can I get the average for this?
- « Previous Replies
-
- 1
- 2
- Next Replies »

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
What dimensions are involved here?


- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Just Month

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
May be this
Avg(Aggr(Count(DISTINCT [Driver ID]), Month))


- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
That's not returning the expected result. It's much lower than it should be.

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
I don't think you have provided enough information to help you with a solution. You need to provide more details


- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
I think the issue is that there is another dimension in a sense. I don't have it specified in the expression, but Vendor is needs to be accounted for as well as Month. I have 2 values for Vendor, VendorA and VendorB.

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Hahahaha then try to add it and check if that works or not.


- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Can it be done using Set Analysis?

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
I don't even know what you have and what you are trying to do... how can I say if set analysis will work or not.
If you don't mind me asking, why are you so vague with your description? Why is there a fear to share a sample

- « Previous Replies
-
- 1
- 2
- Next Replies »