Hi,
When I select the date range (selector widget) which do not have data from datasets there is no effect on table widget. The table widget show all data exists in datasets. If select the date range which have data then the table widget show the correct result.
eg.
From datasets -
Date | Description | Amount |
09/10/2023 | Desc1 | 100 |
11/10/2023 | Desc2 | 200 |
12/10/2023 | Desc3 | 150 |
1) Selector date range = 01/10/2023 to 08/10/2023
Result in table
Date | Description | Amount |
09/10/2023 | Desc1 | 100 |
11/10/2023 | Desc2 | 200 |
12/10/2023 | Desc3 | 150 |
2) Selector date range = 05/10/2023 to 11/10/2023
Result in table
Date | Description | Amount |
09/10/2023 | Desc1 | 100 |
11/10/2023 | Desc2 | 200 |
How to make the result in table become blank for the scenario 1?