Need Rank filter

Q&A
, , ,
1

Capture
Capture220×270 12.2 KB

I need to Rank on Wk5 column and filter top 5 total, but want to display both WK 4 and WK5 for colA
WK4 and WK5 are coming from sameWeek column
Is this possible ? If Yes, how can we achieve it?

2

Hi @Praveena

Welcome to the Quick Sight community!

In the Pivot Table visual you have Top or Bottom filter, that can help you achieve what you want.

Here’s an example screenshot where I am showing Top 2 Skills by the Count of assignments.

image
image730×546 41.6 KB

Regards,
Giri

3

@Giridhar.Prabhu , This works if we have only Wk5
But my requirement is want to pick top n on WK5 and need to show WK4 too
When I do top n, it is picking from both Wk5 and Wk4

4

Hi @Praveena

I don’t understand your point about when I select Top N it takes both WK5 and WK4. I guess the ranking is based on a field.

Can you provide some more details?

Regards,
Giri

5

Hi @Praveena

Can you please try using the rank function.

Example:

rank([WK5 DESC], [])

image
image260×276 9.43 KB

image
image547×611 29.2 KB

6

Here WK4(week 4) and WK5(week 5) both are same dimension coming from week
We have 2 dimensions - ColA, Week and one measure - total here

7

Hi @Praveena

Can you try something like this?

rank([ifelse({week}= “WK5”, {total}, 0) DESC], )

Regards,
Giri

8

Hi @Praveena,
It’s been awhile since we last heard from you, did the last solution provided work for your case or did you have any additional questions?

If we do not hear back within the next 3 business days, I’ll close out this topic.

Thank you!

9

Hi @Praveena,
Since we have not heard back, I’ll go ahead and close out this topic. However, if you have any additional questions, feel free to create a new post in the community and link this discussion for relevant information if needed.

Thank you!