Wondering whether there is a way to sync the movement of the vertical Module scroll bars on Dashboards. My current situation is where I am displaying data from different modules side by side where the same List is used on the rows. I want to only display the List once on the far left but obviously if either module vertical scroll bar is moved then the list items are out of sync between the modules. This primarily is happening where I want do display some qualitative data about the list items and then display some quantitative Time Series data to the right of it
I can create a new list which has a clone version of the time periods required and also the other line items & then all the data could be forced into the 1 module but this is complicated and requires different formulas for list items which slows down the system and defeats the purpose of dimensionality
I really like this question because I've faced this before myself.
I think you already know you can't sync the vertical bars but there might be a better solution to the use case rather than trying to sync the bars.
For a moment though, let's assume you could sync the vertical bars. Notice the employee name is so far away from the time series data that it's pretty hard to figure out which row an employee is on.
A possible alternative to all this is to go ahead and widen the list column (employee name) on the time series. Remove the grid on the left. Instead, add a properties grid of the employee so that when someone clicks on the employee name of the time series, it will show the properties of the employee in the properties grid. You get the benefit of seeing which row is highlighted on the time series plus you get all the properties.
If seeing all the properties of the employees is important you could also set up a filter on each of the properties so when a user selects a property it only shows the employees that have that particular property.
Hopefully this idea doesn't change your use case but it seems like you would get the same benefit.
That is a smart resolution to my problem and is nicer UX. A problem I always have is allowing the end user all the data they require while not overloading the Dashboard with data but this sync with the Employee list property as a Page item is lovely as it allows for maximum data while minimum clutter (and the end user can retain their sanity!)
Would a creating a time dimensioned module along with all relevant dimensions such as employee, department and role with expenses data not satisfy your requirement. You could achieve this with the use of SUM function to combine into a third module and then pivot the views to display the data in any way you wish. This would only be possible this this is an output only view and does not require any user defined inputs.
Chris Heathcote Bedford Consulting
Gold Partner and Regional Partner of the Year 2021, EMEA