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
-
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