Use line Item of a Module as Filters on a Dashboard

[PrevContributor]

Hi , I want to use a combinaision of line items in a module I published as a Dashboard as  filters for that Dashboard. This without creating a Button for refreshing the result in the dashboard but to have it updated automatically according to the selection of those 2 lines Items. Is this possible and how ? Thank you in advance.. Ahmed

[Jaakko]

Hi Ahmed, I think "real-time" filtering is not supported, you must refresh the filtered view (View -> Edit -> Refresh or, use View -> Pivot or refresh the dashboard from the menu) when values of the filter change. It is possible to create filter modules with line items for filtering rules but in any case the views must be refreshed in order to see the results. Unless you are filtering a dropdown list? Can you elaborate a bit more? Thanks. Br, Jaakko

[PrevContributor]

Hi Jaako,   Thank you for your answer.   The point indeed is the real time filtering in the Dashboard.   The module filtering could be a solution indeed, but you have each time in the Dashboard to press a Refresh Button you created before.   Those line Items are not a list but could be as they can have for each one 10 Different values. But I don't want to have them as Dimensions in my module. Thank you. Ahmed

[PrevContributor]

Hi Ahmed, We also do our real-time dashboard filtering through driver modules.  So for example, we'll have a module called Driver Selection, where the only dimension is Line Items.  Then, in our modules where we are displaying data on dashboards, we include the filter criteria in all displayed line items, so that the only data displayed correlates to the filters selected from the driver modules.  This can work for lists or any other data type. Happy to provide more details if you'd like, otherwise hope this helps point you in the right direction! -Chris Weiss

[PrevContributor]

Hi Chriss,   Thank you for your reply, this looks great.    Can you pleasedetail more the way you include the filter criteria in all displayed line items ? Thanks again Ahmed

[PrevContributor]

Hi Ahmed, I'll give you an example from a Territory Management use-case.  If I have a dashboard that shows all territories (which could be an overwhelmingly large dashboard), I may want to have the ability to filter to only show territories within a certain industry within the dashboard, which wouldn't be part of the actual territory hierarchy.   Here's the configuration I would use to enable that filter.  I would have a module called Territories and a module called Filter Drivers.  In my Filter Drivers module I would have a user-entered line item called Industry, which would be based on the Industry list.  I would publish that line item on the dashboard with my all my Territories.   In my Territories module, I would have a line item called Industry, based on the Industry list.  I would also have a boolean-formatted line item called Industry Filter, with the following formula:

Industry = Filter Drivers.Industry

Then on my Territories dashboard, I would filter any displayed modules where Territories.Industry Filter = TRUE.  The result would be, on the Territories dashboard, if I select Healthcare from the Industry dropdown line item from the Filter Drivers module, only the Territories where Industry = Healthcare will be displayed on the dashboard. You can make it as complicated or simple as you like from there (for example, a second boolean line iten in the Filter Drivers module to indicate whether or not to enable the filter, and updating the Territories.Industry Filter boolean accordingly), but this the basic structure. Let me know if there's anything unclear here, happy to help as much as possible, hope that helps! -Chris Weiss

[Jaakko]

Hi Ahmed and Chris, Not sure if I interpreted right but I think the example is not real time from the user point of view or "real-time" how I understand it?  I've done something similar and my hunch is that changing the industry filter changes the boolean values behind the filter but it requires a manual refresh from the menu to see the results? Correct me if I'm wrong. One thing to keep in mind with this type of "selection modules" is that they are common for all users. With many people using the same dashboard you might end up with users changing the same selection (filter) at the same time. Anyhow Chris's solution is a good way to filter items on large dashboards! Br, Jaakko

[PrevContributor]

Hi Jaako, You're absolutely right, and just wanted to clarify 2 quick points. First, with driver selection modules, we typically include the list of users as a dimension, with selective access to only allow each user to set their specific drivers.  This enables dynamic filtering across many users simultaneously using the same dashboard. Second, the dashboard does not need to be refreshed following this approach, since the boolean updates are located within the formula, so the content changes directly in front of the user once the new driver is manually saved.  Perhaps we have different definitions of what we're both looking for in real-time though, so happy to be corrected if there's a different requirement. Hope that helps to clarify, great point Jaako. -Chris Weiss

[e.schera]

Any chance I could get some additional guidance on making the filter dynamic.  No matter how I seem to set up the driver module, I end up with a filter that only allows 1 filter at a time (therefore who ever filters first gets to see that view).  

Thank you, 

Elizabeth

[Jaakko]

I would be satisfied with a real time solution that, in the example, would update/filter all territory lists in all published views on the dashboard when changing the value of the industry list formatted line item in the filter drivers module.  How I believe Anaplan works now: When I'd change the value from Industry A to Industry B, that cell would flash as green color and the "industry filter " boolean line items in territories module would change their values according to my selection but without refreshing the dashboard or a view I would still see territories that would have filter value "false" (that were true before I changed the filter). If this works in a different way for you I must build a quick model and test this. 🙂 It can't be a browser issue, can it?