It's common to need to filter a dashboard based on some value associated to the user. For instance, in a retail environment, you may wish to create a single store managers dashboard, that is automatically filtered to the store the user is the manager of.
To achieve this, we first need to define the data that is associated with each user. We do this by publishing a dataset that contains the user data. This dataset must have the following characteristics:
- The dataset must contain a row for each user defined in inmydata.
- The dataset must include a column that contains the user id matching the user id defined in inmydata.
- The dataset must include a column for each value you wish to be associated with each user.
Once the dataset containing the user data is loaded, you need define it as the user data subject. Follow these steps:
- Log in to inmydata using an account with admin rights.
- From the user menu (top right icon on the screen), select Settings.
- Select the Users tab in the left panel.
- Under User Subject, select the dataset loaded above.
- Under User Id Field, select the column that contains the user id.
- Press OK to save the changes.
Once these steps have been completed, you can use these values in a filter when building a dashboard. To add the filter to a dashboard object, follow these steps:
- Edit the dashboard object you want to filter (double click the object or select it and press edit dashboard object from the ribbon).
- On the Data tab, click on the filter button
- Press Add to add a filter condition
- Select the column you wish to filter against
- Next to the values list, click the Filter Parameter button
- Select the user date value you wish to apply to the filter.
- Press OK to apply the filter condition.
- Press OK to apply the filter.
- Press OK to save the change.
The video below demonstrates these steps: