Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
I am having below data in straight table where Status is dynamically generated based on the expression. Now i want to show summary from the table data. How can show that?
ID | Status | Route | Count |
1 | Available | 6 | 6 |
2 | Available | 6 | 6 |
3 | Change Required | 12 | 12 |
4 | New Requirement | 18 | 15 |
Summary that i want to show -
Available | 2 |
Change Required | 1 |
New Requirement | 1 |
May be try this
Dimension
Aggr(FirstSortedValue(Status, -Route), ID)
Expression
Count(DISTINCT ID)
What are the expressions from your details chart?
Dimension
ID
Expressions
Max(Route)
FirstSortedValue(Status, -Route)
May be try this
Dimension
Aggr(FirstSortedValue(Status, -Route), ID)
Expression
Count(DISTINCT ID)
Thanks Sunny,it worked!!!
Hi Sunny,
Can you please help me on below post?
Show the category based on variable
Thanks in advance.
Ashish