TOP X prompt

Joe Choueiri-Oracle

Hi

I need to pass a numeric value through the Dashboard prompt for displaying the TOPX customers or deals, the user will select a number that I would have already created in the presentation variable prompt such as 10, 20, 30 and when the user select a value then the report/analysis would display top 10 or 20 customers or deals.

I did it one time but I completely forgot how it was done, would you pls help.

Thanks

Joe

Gianni Ceresa

Hi,

Your prompt set a presentation variable and in the formula for your TOP x you use the variable instead of the hardcoded number.

Just make sure to also set a default value in case the variable isn't set (for when you preview the analysis alone and not in the page where the prompt setting the variable is located.

You can also use the same variable to customize the title of the analysis or some other text to tell the user what he is seeing on his screen exactly (despite he did select the number, better be precise...).

Joe Choueiri-Oracle

Thank you Gianni

Just to make sure,

Create a presentation variable

Create a column with a formula like this TOPN("Fact - SSS"."Amount (USD)", @{top_customers}{10}) , called the column Top X

And that is it? no filters, right?

Gianni Ceresa

No, no filters.

The TOPN(....) formula will filter for your directly as you can see in this quick example on a TOP 3.

Joe Choueiri-Oracle

Thank you Gianni as always.