I am trying to make a simple aritmetic operation with two variables in MetaQueries (A['variable 1']/B['variable 2']).
Well the issue I think it comes because each of the variables comes from a different datasource - Therefore the data source selected is "--Mixed--":
Here it is the definition of both variables:
Query A - ALIAS BY "variable 1"
Description: absolute counter for the parts produced over the lifecycle of the machine // with the transformation "difference" I extract relative values per day.
Datasource 1: "ConditionMonitoring"
Query B - ALIAS BY "variable 2"
Description: absolute counter for the energy consumption (electricity) over the lifecycle of the machine // with the transformation "difference" I extract relative values per day.
Datasource 2: "EnergyConsumption"
MetaQueries query:
Note: each variable is displayed in the right way however I receive nothing when I hide all variables except the calculated one:
Furthermore, I have tried to make a simpler calculation (A['variable 1']*2) with the same result.
Has anyone faced this issue? Is there anything wrong in the definition?
Good morning,
I am trying to make a simple aritmetic operation with two variables in MetaQueries (A['variable 1']/B['variable 2']). Well the issue I think it comes because each of the variables comes from a different datasource - Therefore the data source selected is "--Mixed--":
Here it is the definition of both variables:
Query A - ALIAS BY "variable 1" Description: absolute counter for the parts produced over the lifecycle of the machine // with the transformation "difference" I extract relative values per day. Datasource 1: "ConditionMonitoring"
Query B - ALIAS BY "variable 2" Description: absolute counter for the energy consumption (electricity) over the lifecycle of the machine // with the transformation "difference" I extract relative values per day. Datasource 2: "EnergyConsumption"
MetaQueries query:
Note: each variable is displayed in the right way however I receive nothing when I hide all variables except the calculated one:
Furthermore, I have tried to make a simpler calculation (A['variable 1']*2) with the same result.
Has anyone faced this issue? Is there anything wrong in the definition?
Thanks a lot in advance!
Best Regards Adrián