Hi there! I’m trying to use a currency in our dashboard, like a filter where We can see only two variables (Local or CZK) Model is looking like this and I’m able calculate revenue with this filter, but I cannot use country filter, and I’m not sure how I have to change model or my metric 😕 Thanks for helping

Hi I am not sure how your report and metric looks like but the problem may be that country cannot filter exchange rate. Maybe “BY ALL COUNTRY” can help in the metric definition which would tell the engine that the same exchange rate is used for all the countries. Also you may consider making edge between exchange rate and currency multi-value edge (arrows in both directions) if the modeler lets you do it (there are some constraints for models with many to many relationships).

Thank you, Jakub.