
Contributor
2019-01-03
01:33 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Rank in the bar chart
Hi Friends,
I am new to the community. I have the requirement to display bar chart based on highest priority.
If a person has priority 1 and 2 then we need to consider the priority based on the latest date.
Please help how to write the rank script for the bar chart. You can find the data below.
Fruit | Person No | Rank | Date |
Apple | SXXXX1 | 1 | 20180718 |
Apple | SXXXX2 | 1 | 20180925 |
Apple | SXXXX3 | 1 | 20181119 |
Apple | SXXXX4 | 1 | 20180625 |
Apple | SXXXX4 | 1 | 20181016 |
Apple | SXXXX5 | 1 | 20180108 |
Apple | SXXXX6 | 1 | 20180815 |
Apple | SXXXX7 | 1 | 20180813 |
Apple | SXXXX7 | 1 | 20180814 |
Orange | SXXXX1 | 2 | 20180718 |
Orange | SXXXX6 | 2 | 20180815 |
Banana | SXXXX2 | 3 | 20180925 |
Banana | SXXXX6 | 3 | 20180815 |
Grape | SXXXX1 | 5 | 20180718 |
Banana | SXXXX3 | 3 | 20181026 |
Grape | SXXXX5 | 5 | 20171124 |
Orange | SXXXX5 | 2 | 20180101 |
Attached Sample of the chart:
2,638 Views
- « Previous Replies
-
- 1
- 2
- Next Replies »
11 Replies

Contributor
2019-01-08
03:50 AM
Author
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Hi Aiolos Zhao,
i have written the expression as follows but the outcome is similar like you. some of the persons are tagging to both CA and DA. Please advise me how to restrict the persons.
Dimension:
AGGR(FirstSortedValue([Action],RANK_Level),[C_ID])
Expression:
Count(distinct(C_ID))
469 Views


Partner - Specialist
2019-01-08
08:43 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Have you seen my qvw?
I said I add the data source for testing the expression, have you seen it?
I think my expression is what you want, if not, please tell me what you want using my data.
I said I add the data source for testing the expression, have you seen it?
I think my expression is what you want, if not, please tell me what you want using my data.
467 Views

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