I’m reaching out for assistance with a table visual that includes multiple date fields—specifically, I have 10 different date fields. To filter the data, I’ve implemented start date and end date parameters to enable dynamic filtering.
Now, I have a specific requirement: I’ve created a KPI (Card visual) that displays certain values, such as product information. I want to add an action to this card so that when I select it, the table provides all the detailed information along with the 10 different dates.
To accomplish this, I need to set up a manual action. However, it’s important to note that I have multiple cards, and each card contains different dates that utilize the same logic.
is it write you want to filter the table based on KPI visual field. e.g. KPI visual is contains product “shoes” data, if you select the KPI visual you want to show only shoes date in the table?
I wanted to share the details of our tracking table, which includes the following entries:
Order Date
Manufacturing Date
Quality Check Date
Packet Date
Dispatch Date
Delivery Date
Received Date
Returned Date
Replacement Date
This table encompasses all relevant information related to the product.
Additionally, I have several Key Performance Indicators (KPIs) to monitor our progress:
Number of Orders for Shoes KPI
Number of Manufactured Shoes KPI
Number of Quality Check Shoes KPI
Each KPI includes Start Date and End Date parameters that allow us to filter data for a specific time period effectively. For instance, when I click on any of the “Orders for Shoes” KPIs, it will display the number of shoes ordered along with the corresponding date-related details in the table.
If you need any further information, please feel free to reach out.
Hi @Vaibhav.narwade ,
you could create a filter action on the KPI to filter the table with the date field. KPIFilterAction
But it is inconvenient to reset it again and you only can select one date.
BR