Dear visitor, despite the COVID-19 outbreak, our team continues operating at full speed.

Also, here is the form where you can apply for a special discount and we will contact you with possible options. Stay safe and continue achieving your business goals.

Fill the form
Get Free Trial
Get Free Trial

NEW! Pivot Table for MongoDB: a new approach to visualize your database

Answered
Jason Whetton asked on February 13, 2020

Hi,
Does this connector have support for formulas?
 
Thanks.

14 answers

Public
Mykhailo Halaida Mykhailo Halaida Flexmonster February 13, 2020

Hi Jason,
 
Thank you for posting your question.
 
We would like to confirm that calculated values are supported in Flexmonster Pivot Table for MongoDB.
 
However, please note that the `individual` parameter of the `measure` object is currently not supported for this data source, as it requires access to raw, unaggregated data. This is not possible with MongoDB, because in this case all the aggregations are calculated on the server-side before the data is transferred to the pivot table.
 
Feel free to check out the following documentation page for detailed instructions on how to use calculated values in Flexmonster: https://www.flexmonster.com/doc/calculated-values
 
Please let us know if this helps.
 
Best regards,
Mykhailo

Public
Jason Whetton February 13, 2020

That’s great, thanks.
Do you know at this time whether the Elasticsearch connector will be updated to support formula?
 
 

Public
Mykhailo Halaida Mykhailo Halaida Flexmonster February 14, 2020

Hi Jason,
 
We do have plans to move the Elasticsearch connection to the custom data source API model, which will make it possible to use calculated values with Elasticsearch.
 
At the moment, we are not able to provide you with a precise ETA for this, but we will make sure to let you know once there are any updates on this matter.
 
Please let us know if you have any other questions we can help you with at the moment.
 
Best regards,
Mykhailo

Public
Jason Whetton February 21, 2020

Hi,
I’m having trouble with the MongoDB sample project on a Mac.
 
The line 

rmdir /S /Q "build/" && tsc

fails when running

npm run build
Public
Mykhailo Halaida Mykhailo Halaida Flexmonster February 21, 2020

Hi Jason,
 
Thank you for reporting this issue.
 
We’ve updated the sample project on GitHub and tested it – the error is now resolved and everything is working fine.
 
Could you please clone the updated version of the project and let us know if the issue persists on your side?  
 
Thank you in advance and looking forward to hearing from you.
 
Best regards,
Mykhailo

Public
Jason Whetton February 21, 2020

Sure, will give it a try.
Another question – how can we get flexmonster to apply specific headers to the request? We’re planning to use your demo project as a starting point for a proxy but want to pass in a jwt to authenticate the requests.
 
Thanks!

Public
Mykhailo Halaida Mykhailo Halaida Flexmonster February 21, 2020

Hi Jason,
 
This can be achieved using the requestHeaders property of the dataSource object, which itself is an object containing key-value pairs, where key is a header name and value is the header value.
 
For more info on the data source object and all its properties please check out the following page: https://www.flexmonster.com/api/data-source-object
 
Please let us know if this helps.
 
Best regards,
Mykhailo

Public
Jason Whetton February 23, 2020

Hi,
Thanks that helps a lot.
We’re close to a deployed solution now.
A couple of things:

  1. I think it would really make sense to provide a dockerfile with the project. I’m happy to contribute ours.

2. When I tested formula, the formula just dissappeared when I saved them. Could this be a bug?

Public
Mykhailo Halaida Mykhailo Halaida Flexmonster February 25, 2020

Hi Jason,
 
Thank you for your offer to provide us with a sample dockerfile, it could be put to good use. Could you please send it to us via email so that we can inspect it & release it after that?
 
Speaking of your second point, we did not manage to reproduce the described behaviour. On our side, the calculated measure was saved successfully and available on the bottom of the “All fields” window in the Field List.
 
Perhaps, you could share your report and data sample with us so that we can try to reproduce the issue with your configurations? It would also be helpful for our investigation if you could describe the exact steps you’ve followed before running into the issue.
 
Looking forward to hearing from you.
 
Best regards,
Mykhailo

Public
Jason Whetton February 25, 2020

Hi,
I can’t reproduct it either now!
Another question – when I set the Bson type in our documents to Bson Decimal128, it appears as a binary array in the fields editor.
Is that expected behaviour?

Public
Mykhailo Halaida Mykhailo Halaida Flexmonster February 26, 2020

Hi Jason,
 
Thank you for reporting this behaviour.
 
This is a known issue which we’ve encountered earlier and we are going to fix it in the upcoming 2.8.2 release ETA March 10th.  
 
Please let us know if there is anything else we can help you with in the meantime.
 
Best regards,
Mykhailo

Public
Jason Whetton February 26, 2020

Great, look forward to the new release, thanks!

Public
Mykhailo Halaida Mykhailo Halaida Flexmonster March 12, 2020

Hi Jason,
 
We are glad to announce that the issue with Decimal128 type was fixed. This is included in the 2.8.2 version of Flexmonster: https://www.flexmonster.com/release-notes/
 
You are welcome to update the component. Here is our updating to the latest version guide for assistance: https://www.flexmonster.com/doc/updating-to-the-latest-version/ 
 
Please let us know if everything works fine for you.
 
Best regards,
Mykhailo

Public
Jason Whetton March 12, 2020

Great!!! Thanks.

Please login or Register to Submit Answer