Leveraging Synchronize Scroll on Same List Structure with and w/o Time
Hi Everyone,
Looking to see how others are addressing a certain build request. We commonly get the request to have attribute information next to a metric that is also dimensioned by time. An approach we have started using is having two modules on the same UX page leveraging synchronize scroll. This allows us to have flexible time filtering/aggregation while also showing relevant information for line items. There are some inherent drawbacks. You have to turn off the native filtering/sort and add specific filters otherwise the views can get out of sync.
What are some other approaches being used for this type of request?
Additionally, users will request being able to export and import back into these modules which presents another challenge. Ideal situation would be to export all of the data together in one output for ease of use for the end users. A couple possible solutions we have thought of:
1. Have users export both modules, combine with copy and pasting in excel. Make adjustments and then import as 1 file using 2 export actions within a process.
2. Create a template module that has time periods as a line item along with the attributes to export as a single file. I personally do not like this approach do to the maintenance required for a yearly model rollover.
3. Create a template module that has "relative" time as a line item along with the attributes to export as a single module (1 is understood to always be associate with the first period in time range of the module, Ex. 1 = Jan 2025, 2 = Feb 2025). Then create a module to map the relative time back to the native time on the import.
Any other ideas?