MR question

Hi @Jsdeloria21 ,

If the requirement is to always display current month + past 3 months of data, then it would be a straight forward time filter in a SYS module that you can define and apply to chart and grid cards (you won't need context selector in this case).

But your requirement seems to allow user to change the time selection. Please note that you can't publish an editable card (field card) for user to change on MR, like we do on other UX pages. The only way you can achieve this is to allow user to make time selection on a normal UX page, and use that selection to filter the months you display on MR. You might display the selection and a link to the page where it is selected, like shown in this sample:

If you use context selector, and hence turn on hierarchy filter for Time, the cards will show months falling in same quarter based on selected month , but not as current month + past 3 months.

Lastly, please ensure you maintain same filters/time settings for both chart card and grid card, to display same months as per the ask.

Cheers!

Thanks for explaining.

I am able to replicate the 'issue' here, and it's not just the table/grid, but also the graph, that doesn't get updated, when we change the current month (either through model time settings or through time formatted lineitem) and try refreshing the MR using MR's default refresh icon.

Instead of refresh icon, if you close the MR or just go back to any other page and revisit MR, you should find both the graph and table getting updated (as long as you have same filter applied for both of these cards without any time sync).

While this is not the best work around and I'd recommend raising a support ticket for this, the alternate method that I suggested above, is to use a user dimensioned time-formatted lineitem (field card) on a different page, and use that to filter your time, which works just fine - since this indirectrly involves user having to visit a different page for changing time selector and coming back to MR, which thus refreshes both chart and the grid. Steps in detail:

1. Create a user dimensioned module with timeperiod formatted lineitem for user to select month
2. Define time filter as shown in snapshot below
3. Publish lineitem defined in (1) on an admin page or on the page that falls prior to MR, from where user can select/change the month
4. Filter table and chart on MR using the filter in (2)
5. You might want to add a navigation link to page mentioned in (3), on MR, for ease of access for user

Cheers!

Since we can't add editable selector on a MR, and even a context selector will not serve your purpose (to filter current month and past 3 months for every 'selected month'), my alternate is to publish 'Select Time' on a different UX page for user to choose a month (Dec 22 or Jan 23 in your example), and based on this selection, we filter chart and grid to show selected month + relative past 3 months.

Please note in my snapshot above that 'Select time' is used to filter required months in SYS module.