Hello everyone,
I have a table displayed on a UX page (a worksheet) containing multiple line items in the columns and a list of months also as a column (where each month is a child of a quarter, which is a child of a year).
I need to address two challenges:
- Filtering Data by Months or Quarters:
I aim to enable users to choose between viewing the data by months or quarters. However, I'm using only the month list, and quarters are the parent. How can I achieve this functionality? My idea is to implement a checkbox (as insight card) allowing users to toggle between months and quarters, but I'm uncertain about the process. - Focusing on Specific Line Items:
In the table, there are multiple line items, and I want users to be able to focus on one specific line item at a time . For instance, if there are four line items displayed, users should have the option to select and view only one of them. I believe creating a line item subset by making a module with dimensions of the line item subset and the user could help. Then, I would use a boolean to filter data based on the user's selection, but I need guidance on the implementation. ( i'm also using a card insight for this one)
I appreciate any advice or suggestions you can offer on these matters.
Thank you for your support!
