The other m download6/13/2023 ![]() ![]() It sounds like the issue is that the common table at the bottom of the report page is not filtering the data based on the same conditions that are used to calculate the metrics displayed in the visuals. Please help solve this issue or help us find an alternative method. The table does not respect the date filter that is applied and any condition which is applied in the metric. For example, if we click on a bar showing "Ending Headcount" for "Males", the data table filters all the males correctly but the number of employees in the table does not match the ending headcount number. Now, we added a common table at the bottom of the report page to export the employee level data, however, when we try to filter the table by clicking on any bar/column in the visuals, we noticed that the row count in the data table does not match the selected metric. These metrics are used across different visuals on the page. We use conditions with different dates (like date of joining and date of exit) to calculate important metrics like Starting Headcount of the company, Ending Headcount of the company, Added Employees, Exited Employees, etc. The date table does not have any relation with the attribute table. We are using an independent date filter on the report to filter the measures. Below is the way we are trying to achieve this but its not working. Our objective is to give an option for user to see raw data when they click on any visuals. ![]()
0 Comments
Leave a Reply. |