Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
I am trying to get the max count and name fo first user.
Cany anyone help me in doing so.
1. Straight Table
2 Dimension: SYSTEM_CREATED
3 Expression1: FirstSortedValue(USER,-Aggr(COUNT(USER),USER,SYSTEM_CREATED))
4 Expression2: =Max(Aggr(Count(USER),USER,SYSTEM_CREATED))
SYSTEM_CREATED | USER | Max Count |
---|---|---|
CLA | Sent | 15 |
GOL | Chri | 35 |
LOI | Rame | 1 |
QUO | Dani | 7 |
SES | Geor | 6 |
I am getting the result but CLA sent count is showing 16 which is incorrect.
2. When I am creating a list box Region on clicking the USA it not reflecting the name of User in the straight table.
Hi Bijay I tried same on front end and as well as back end but i got same result in both .
Please go through with the attached qvw for better understanding.