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

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

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

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

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

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

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

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

Hi Jason,
 
Thank you for your question.
 
The issue with MongoDB connector performance is a known problem – the whole collection needs to be scanned when executing a query and if the collection is massive, it naturally takes more time to be executed. 
 
Nevertheless, we are planning to improve the performance with the help of caching and further query optimization – we will make sure to let you know once there are any updates on this.
 
Answering your question regarding indexing, from our experience the indexes for aggregation pipelines are not very efficient and do not help a lot when it comes to query optimization.
 
Please let us know if you have any other questions we can help you with.
 
Regards,
Mykhailo

Hi Jason,
 
Thank you for your suggestion – we've discussed this with our team and it seems to us that adding support for  $indexStats would be reasonable.
 
With that in mind, we've added this feature to our todo list – we'll return to you with updates once there is enough progress with the whole MongoDB connector optimization process.
 
Please let us know if there is anything else you would like to discuss in the meantime.
 
Kind regards,
Mykhailo

Hi Jason,
 
Hope you're doing well!
 
Major MongoDB Connector updates have been introduced in the latest Flexmonster release, including performance optimization, logging, and cache management.
 
In particular, logging can help ensure the queries are hitting the indexes – we thought you might find this interesting.
 
If so, feel free to check out the following blog post for more details: https://www.flexmonster.com/blog/mongodb-pivot-table/.
 
This is included in Flexmonster v. 2.9.0: https://www.flexmonster.com/release-notes/. 
 
You are welcome to update the component. Here is our updating to the latest version tutorial for guidance: https://www.flexmonster.com/doc/updating-to-the-latest-version/. 
 
Best regards,
Mykhailo

Hi Jason,
 
How are you?
 
Just checking in to ask if you've had a chance to try out the latest MondogDB Connector. Was there something that caught your eye?  
 
We'd be happy to hear your feedback.
 
Best regards,
Mykhailo