4 Replies Latest reply on Dec 27, 2017 1:28 PM by Hari Ankem

How do I show my top 3 to look like one 'set of string'?

Alysse Mea Dec 26, 2017 9:42 AM

I have a dimension called Reason and wanted to show the top 3 Reasons. Top 3 will be the top 3 number of records with the given Reason. In the table below:

Reason	Number of Records
Fall	44,658
Days	44,045
Months	37,017
Winter	35,390
Spring	23,229
Years	20,052
Summer	9,228

I want my view to be: Fall (44,658), Days (44,045), Months (37,017). I need it to be a calculated field, converting each to string and combining them all. Top 3 may or may not change.

Please help! Thank you and Merry Christmas!

1. Re: How do I show my top 3 to look like one 'set of string'?

Shinichiro Murakami Dec 26, 2017 3:41 PM (in response to Alysse Mea)
Hi Alysse

I hope I understood your request correctly.
You need to create couple of layers of table calculations.

Now you need to filter 3rd item.

Thanks,
Shin

Top3_String.twbx 28.7 KB

1 of 1 people found this helpful
Like Show 1 Likes(1)

Actions
2. Re: How do I show my top 3 to look like one 'set of string'?

Hari Ankem Dec 27, 2017 9:36 AM (in response to Alysse Mea)
Here is another solution:
Hope this helps.

Top 3 String.twbx 13.8 KB
Like Show 0 Likes(0)

Actions
3. Re: How do I show my top 3 to look like one 'set of string'?

Alysse Mea Dec 27, 2017 12:37 PM (in response to Hari Ankem)
Thank you Shin and Hari! Very helpful. I was able to follow your examples but when I added the dates to my sample data, I got lost again.
I attached my sample workbook. My top 3 would be:
But I am getting this:
I think I need to do sum([total]) but I need help again please. Thank you

Book3.twbx 17.2 KB
Like Show 0 Likes(0)

Actions
4. Re: How do I show my top 3 to look like one 'set of string'?

Hari Ankem Dec 27, 2017 1:28 PM (in response to Alysse Mea)
OK...since you have multiple records for each reason now, the formula needs to be changed as shown below. Also, please remember that you need to add the Reason filter to context.

Book3.twbx 30.1 KB
Like Show 0 Likes(0)

Actions