asked on June 1, 2021
Is there a way to add a non-additive measure? Setting aggregation to none does not seem to work.
⋅ June 2, 2021
Hello, Jason,
Thank you for reaching out to us.
We suggest considering one of the following approaches:
visible property of the Mapping Object to false.id in the mentioned mapping object.
If these options are not suitable for you, please provide us with additional information about how this field is gonna be used in your case.
Looking forward to hearing from you.
Regards,
Illia
⋅ June 7, 2021
Those options do not appear to be working, maybe you can provide an example?
In my case I have a value for the number of days under review which should be the same for all values, no matter if it is drilled down or rolled up in a summary. This value is used in another calculation. For example I am looking at 180 days of data and the 180 should be the same value for every data element I am looking at.
⋅ June 9, 2021
Hello, Jason,
Thank you for the clarification.
If we understand correctly, your requirement is to have some constant value that would not be aggregated and serve to compose calculated values.
In case our assumption is correct, we suggest using max or min aggregation in order to represent this value as a constant. We have prepared the following JSFiddle for your reference: https://jsfiddle.net/flexmonster/28aqcufj/. It demonstrates how to use the "Tax" field as a constant instead of aggregating it along with other values. The "Tax" field is used to compose a calculated value "Total price with taxes".
Please let us know if it works for you.
If we did not get the idea correctly, please provide us with a detailed illustration of the desired functionality.
Looking forward to hearing from you.
Kind regards,
Illia