hi, I am trying to run a visual where one metric is filtered by a date in one table but then I need a count of details from another table. when it is filtered on the date from the first table I am not getting a total count. this is hte visual https://autoflow-dev.cloud.gooddata.com/analyze/#/ad276fc1-449f-46b1-9bac-aaeaf013d5be/194c70ec-6df4-46d9-93c7-a53eec12e93f/edit

Hi Chris, I have taken a look at the insight in question and can see three different metrics in it alongside several date dimensions. Could you please specify what date dimension is not making the metric getting filtered? Please be aware that for the date dimension to filter correctly the insight, you will need to ensure it is fully compatible with the elements in the metric in question, i.e., it must be properly connected in the LDM to the corresponding dataset. Feel free to provide the details via DM if this is more comfortable to you in caes there is sensitive data involved.

The main metrics that I need are "% of jobs with a Hire Vehicle" and "Count of Jobid" the job id is being limited to where it has a link with the hire start date but I need it to not use that link

I see. In that case, could you try clicking "show missing values"? This will display all attribute values, even if the metric values are missing. I suggest checking first on a table visualization if this is the intended result, if so, please be aware that the missing values features cannot be used on a headline visualization. In such case, you will need to create a metric with FOR EACH: https://www.gooddata.com/docs/cloud/create-metrics/maql/time/for-each/ Example syntax:

SELECT ... BY ... FOR EACH (attribute/label), (attribute/label), ...

Thanks I will take a look