• 6 September 2022
  • 2 replies

Userlevel 3
Badge +3

hello :) 

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 francois 6 September 2022, 15:14

View original

2 replies

Userlevel 6
Badge +7

Hi Alix,

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"]

Userlevel 3
Badge +3

Thanks, the way to chain properties is good!