I have two diferent metrics I have created. I want to combine them, but depending of a field in a category. I have the date as follow:
So I want to combine both metrics (Cost/t with Cost/T Fines), but depending which raw material it is. Only if the raw material if "Fines" I want the value of Cost/T Fines, and for the rest the other value.
I have tried creating the followin metric:
But I get the following error: "It is not possible to mix aggregation and non-aggregation comparisons or results in "IF" expressions"
Is there something am I missing?
Thank you very much in advance!
Hello Jim.
Thank you very much, this was really helpfull.
The only thing right now, it that the total of the measure, is not calculating correctly:
I have market in green the correct values I get with the measure, but the total is not adding up correctly. I´ll attached a picture of each measure to see if I have missed something:
Thank you very much in advance!
