how to get calculated value ?

Answered
Patrick TAVARIS asked on October 25, 2021

Hi,
I've a flexmonster table with some calculated value in report/slice/columns.
I want to be able (programmatically, in our js code) to get the calculated result for a given calculated column that is currently in my [Measures].
How can I do that ?I've not found answer on your documentation.
 
Something like flexmonster.getCalculatedResult('myUniqueNameCalculatedField'); 
In my use case I want to grab the grand total for this calculated uniqueName column.
Regards

5 answers

Public
Nadia Khodakivska Nadia Khodakivska Flexmonster October 26, 2021

Hello, Patrick,
 
Thank you for contacting us.
 
Could you please give us more information about your use case and what you are trying to achieve? That would help us to find a suitable solution for you.
 
Looking forward to your response.
 
Kind regards,
Nadia

Public
Patrick TAVARIS October 26, 2021

I'm trying to use a calculated value outside flexmonster (in the same page but on a different piece of code).
The issue is that I don't find any method to let me do it.

Public
Nadia Khodakivska Nadia Khodakivska Flexmonster October 26, 2021

Hi,
 
Thank you for the additional information.
 
For your use case, we suggest using the getData API call. Please check the following example of getting the grand total on the JSFiddle: https://jsfiddle.net/flexmonster/h4cyfb6t/ 
 
Feel free to contact us if other questions arise.
 
Kind regards,
Nadia

Public
Nadia Khodakivska Nadia Khodakivska Flexmonster November 2, 2021

Hello, Patrick,
 
Hope you are doing well.
 
Could you please confirm if the solution works well for you?
Looking forward to hearing from you.
 
Kind regards,
Nadia

Public
Nadia Khodakivska Nadia Khodakivska Flexmonster November 9, 2021

Hello, Patrick,
 
Hope you are doing well.
 
Just checking in to ask if the solution was helpful for you?
We will be glad to hear your feedback.
 
Kind regards,
Nadia

Please login or Register to Submit Answer