0

Usage of the Count Function in Present

This may be a pretty basic question: I have a presentation that allows users to select multiple elements from a slicer. I would like to place a dynamic text box that displays the count of selected elements for the user's query.

 

How do I accomplish this ? I have no trouble with the dynamic text or interaction portions of the problem, but I am struggling with how to get the count of selected elements from this slicer.

I have tried using lists and formulate, but I cant quite get it. 

1 reply

null
    • Brendan_Conway
    • 3 days ago
    • Reported - view

    Hi Alexander, good question! I think the key here is to let the slicer do the work with interactions. In my example, I have a "Product" slicer, and a simple grid with Sales by Product. 

    Step 1: I create a slicer for Product

    Step 2: I create a new discover that is simply the Distinct Count of Product (can use a quick calc on the Product dimension). This doesn't have to be in the Present, just using it for dynamic text references.

    Step 3: Create dynamic text pointing to the data value of the distinct count (I used Autoformat to clean it up a bit)

     

    Step 4: Create an interaction between the slicer and the dynamic text - this will allow the value to filter down as you select 1 or more elements. 

    Let me know if you have any questions about the solution. 

    Thanks!

    Brendan

Content aside

  • Status Answered
  • 3 days agoLast active
  • 1Replies
  • 21Views
  • 2 Following