Variable results on dashboard depending on user selection

CommunityMember83188

I want to present a dashboard where the information displayed varies depending on the year/version the end user selects - see attached picture of example.

 

The modules that lie behind this example would be as follows:

 

Input-Module 1

Input Cost - user input (Dimensions - Location List, Version List, Year)

 

Calculation-Module 2

Line item 1 - formula = 'Input-Module 1'.Input Cost[LOOKUP: Filter-Module 3.Select Version, LOOKUP: Filter-Module 3.Select Year] (Dimensions - Location List)

 

Filter-Module 3

Select Version - user input from drop down (Dimensions - none)

Select Year - user input from drop down (Dimensions - none)

 

The dashboards would be accessible by a number of end users, some of whom could be using the dashboards at the same time: Is there a reason for not building the model this way?  The actual model would contain lists with many items and I am looking to save space in the calculation module by not having it dimensioned by Time/Version (and I would be looking to use similar method for adding other functionality like currency conversion)

Example_Dashboard_52224.png

VIGNESH.M

Hi,

 

If you are using this grid for reporting purpose, then add User Dimension in INPUT MODULE and CALCULATION MODULE.

Adding a user dimension will allow each end-user to select the list they want and can see the result based on their selection.

 

You only have 3 dimensions in Calculation Module, it won't take much size. It's better to create a module with these 3 dimensions and remove the input module.

 

Thanks,

Vignesh M