Synchronize Dashboard based on quick filter

KamaniRagaDeepthi

Hi,

Is there a possibility to synchronize a dashboard based on the quick filters used by the end user?

If 2 grids from different modules with the same dimensions and different line items are published to a Dashboard, is there a way to apply a Quick filter on any of the line items of one of the grids and see only those list items in the other grid as well?
If not, is there an alternative to this?

Any suggestions or inputs would help!

Thank you in advance 🙂

Accepted answers

All comments

Misbah

@KamaniRagaDeepthi

I don' think so. Quick filters can't do that job for you.If I may ask why the need to do so, what are you trying to accomplish? I understand that you want to filter a line item in another module based on filtered line item in first module - but Why?

einas.ibrahim

Hi @KamaniRagaDeepthi

Depending on what data the end-users want to filter, you could consider having a filter module on the dashboard. Connect the filter module to both modules and display the data (filtered) based on the user selection on the filter module.

jamancuso

Hi,

While there is no way to use the quick filter functionality to filter multiple modules, you can use another module for input (dimension, text field, time period, date, number or boolean) and a corresponding boolean for your filter. Below is a simple example.

Line Items In New Module

Input Selection: Strawberries (Fruit List Format, No Dimensions)

Filter A: item(fruit)=Input Selection (Fruit Dimension)

Filter B: item(Berries)=Input Selection (Berries Dimension)

Module A (Dimension Fruit) Module B (Dimension Berries)

Oranges Kiwi

Apples Strawberries

Bananas Oranges

Strawberries Blackberries

In this scenario, publish the input selection to the dashboard, apply filter A to module A and filter B to module B. The last step is creating an action that refreshes your dashboard to update the filters once a new selection is made. Simply add an open dashboard action to open the same dashboard you're using and it will refresh the filters.

SwagatZS

Hi @Misbah @einas.ibrahim @einas.ibrahim

Hope you are doing well and staying safe. Thanks for your inputs.

To provide some more context:

We have two modules published on a dashboard:
- Module 1:
  - Dimension: List 1
  - Line Items: Date 1, List formatted line item 1, 2, 3 and Numeric line items 1, 2, 3 (these line items don't change based on time)
- Module 2:
  - Dimensions: List 1 and Time (Months)
  - Line Items: Text line item
We have been asked to put both the line items and the months (as line items) in module 1 but that will not be best practice as it would require ongoing maintenance every time the year changes and is also slightly tricky from architecture standpoint.
Thus, we want to check if it there was away for the user to apply a filter or a sort based on any of the line items in module 1, and have the module 2 should filter or sort accordingly.
- If you have any other ideas to solve this problem, please do let us know.

Also, please let us know if you have any other questions that would help clarify the ask.

Best,

Swagat

jamancuso

An article that I think would be helpful for the filtering process would be: https://community.anaplan.com/t5/Best-Practices/Increase-End-User-Adoption-With-Smart-Filters/ta-p/42821 . It walks through many different examples of the types of filters you can use and apply to your situation. For the sorting, all you need is a line item in module 2 that numerically assigns a number (ranks the list items 1 - # of list items) based on the inputs in module 1. Once you apply the sort, if you refresh the dashboard your sort will update based on your inputs.

SwagatZS

Thanks @jamancuso for your suggestions. They definitely seem useful. We will try these out and let you know the outcome.

Best,

Swagat

SwagatZS

Hi @jamancuso ,

Hope all is well.

We created the filter functionality per your suggestion however the client team has asked us to consolidate the information in one table instead of one. What that means is that we have been asked to create separate line items, one for each month of the year in module 1 which is not dimensioned by time. We are working with the Anaplan team to see if there is a better way of working this out.

Please do let us know if you have any ideas on how to best to build this out in one module instead of two.

Best,

Swagat

Quick Links

Can you help?

Unanswered questions

Batch Script
Hello team, I am logging into Anaplan through SSO. I would like to create a batch script to import a file into Anaplan. For the Spoke model, I would like to run an process via a batch script to import data from the Data Hub. Can anyone provide me script for both the condition.
import monthly data with months in columns
is there a way to import data with months in columns (usual excel table view)? I have to transform the data so there are rows to cover each period in the upload data form, but I am wondering if there is a better way to just import the data as is with the months in the columns. please let me know what you think. thank you,
Cloudworks Big Query Integration Fail
Hello, I am receiving an 'Anaplan Upload Failed' Status Description when testing my integration with a Big Query dataset. The integration imports data from BQ to our Anaplan model. No other details given in the error log. I suspect that Cloudworks is not even picking up the file but am not sure what we did wrong on the set…