1 Reply Latest reply on Jul 26, 2018 8:24 AM by Sandeep Punjari

Dynamic TOP N that changes as new annual data come in

Tuan Tran Jul 26, 2018 7:25 AM

Hi all,

Lets say I have export data by country and year, however as the new annual data come in every year, top exporting country by the latest year changes. How do I have my line graph automatically update so that the new top N countries are automatically changed based on latest year data and the graph chooses these countries, replacing last year top exporting countries?

1. Re: Dynamic TOP N that changes as new annual data come in

Sandeep Punjari Jul 26, 2018 8:24 AM (in response to Tuan Tran)

Hello Tuan,

Try to add a calculated field with index().
then for filtering top N rows use the following calculation and place it in filter box making it as context filter.
index()<=(Number of rows you want to show 'N'.)

Sort the Countries using that measure in descending order.

Let me know if it works out for you.
Like Show 0 Likes(0)

Actions

Tableau Community Forums

Dynamic TOP N that changes as new annual data come in

1. Re: Dynamic TOP N that changes as new annual data come in

Sign In or
Create your Account

Actions

More Like This

Sign In or Create your Account

Sign In or
Create your Account