I want to apply a filter on a metric, it tells me that it can be converted to dimension and i do not undertand why.
This is the initial metric:
And i want to apply this filter: [FILTER:'Job Id'.Contrat = Contract.'Included in People Costs']→ in order to compute costs only for contracts that are included in people costs
Best answer by francoisView original
I think you’re trying to chain properties, like
[FILTER:'Job Id'.Contrat.'Included in People Costs']. In that case, you’re filtering on the Included in People Costs condition on the Contrat of the Job Id.
If however you want to Filter based on a Contrat of a Job Id that is a Contrat item called Included in People Costs, in that case you’d use double quotes
[FILTER:'Job Id'.Contrat = Contract."Included in People Costs"]- but I don’t think that’s what you’re trying to achieve here. This would be useful with a formula like
[FILTER:'Job Id'.Contrat = Contract."Fixed Contract"]
Thanks, the way to chain properties is good!