asked on April 7, 2025
Hi guys,
I'm having problems trying to getting calculated values using the flexmonster data server, in this case I'm putting the formula into the slice in the measures section and in the report mapping (See image 1 and 2), once the report is triggered by the data server is not retrieving data for the calculated values (take in account that in the request the fields who are needed to calculate those formulas were requested) in the image 3 and 4 you can see the data server request and their results retrieving an empty object and in the field list those fields were unchecked as formula field and it is using the same mapping and slice config (see image 5 and 6).
⋅ April 9, 2025
Hello Jean,
Thank you for contacting us.
We recommend removing the calculated values objects from the mapping (image2.png) and only define them in the slice.measures object (image1.png). If the issue still occurs after removing calculated values from the mapping, please modify the following JSFiddle to show us the issue: https://jsfiddle.net/flexmonster/12bzwryx/. It would greatly help us.
Looking forward to hearing from you.
Kind regards,
Nadia
⋅ 3 days ago
Hello Jean,
Hope you are having a great week.
We were wondering if you had a chance to check the suggested approach. Did it help to solve the issue with the calculated values?
Looking forward to hearing your feedback.
Kind regards,
Nadia
⋅ 2 days ago
Hi Nadia,
Yes, we solved it with your suggestion, thank you very much.
⋅ 2 days ago
Hi Jean,
Thank you for the feedback!
We are glad to hear that it works for you.
Do not hesitate to contact us if other questions arise.
Kind regards,
Nadia
