Forum Discussion
How to filter distinct count across multiple dates
The reason for the count not showing what you expected it to show is possibly because of a problem with the relationship between your two tables, as you are running a distinct count on the values in one table based on the dates in the other. Does this make sense?
Does your Appointments table have a column for Company Name? And does this column have an active relationship with the equivalent column in your Companies table?
Also, how are you wanting to visualise the data? Card, Matrix...?
Bullius,
Many thanks for your response; having reviewed the existing (active) relationships I made a change to the "cross filter direction" from "single" to "both" and this resolved the issue.
Thank you again for your time and efforts in pointing me in the right direction.
Are you able to give an example of what your data actually looks like?
Bullius,
Below is what I'm able to generate which includes the correct date critera, however pulls back all the meetings for that particular company. In this case, Company 1 had 4 meetings take place within the date period - however I would want the counter to be one for this company.
The reason for the count not showing what you expected it to show is possibly because of a problem with the relationship between your two tables, as you are running a distinct count on the values in one table based on the dates in the other. Does this make sense?
Does your Appointments table have a column for Company Name? And does this column have an active relationship with the equivalent column in your Companies table?
Also, how are you wanting to visualise the data? Card, Matrix...?
Bullius,
Many thanks for your response; having reviewed the existing (active) relationships I made a change to the "cross filter direction" from "single" to "both" and this resolved the issue.
Thank you again for your time and efforts in pointing me in the right direction.
Glad to help!