
Creator
2017-02-28
09:52 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Average Count
I'm trying to figure out an expression that will take the average count. I tried Avg(Count(FTE)) but it tells me there is no data to display.
5,488 Views
1 Solution
Accepted Solutions
2017-02-28
10:02 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Try this
Avg(Aggr(Count(FTE),Dimensions1)
Best Anil, When applicable please mark the correct/appropriate replies as "solution" (you can mark up to 3 "solutions". Please LIKE threads if the provided solution is helpful
2 Replies

MVP
2017-02-28
10:01 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
You are counting FTE over which dimension here? Is this in a chart or text box object?
5,170 Views
2017-02-28
10:02 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Try this
Avg(Aggr(Count(FTE),Dimensions1)
Best Anil, When applicable please mark the correct/appropriate replies as "solution" (you can mark up to 3 "solutions". Please LIKE threads if the provided solution is helpful
