asked on April 23, 2019
Hi,
I'm testing the datasource Elasticsearch and I want to now if calculated values will be avaiable for it sometime.
⋅ April 23, 2019
Hello, Mario,
Thank you for your question.
We would like to confirm that at the moment calculated values are not available for Elasticsearch.
However, we agree that it would be a nice feature to have and have added your request to our customers' wishlist.
Our team will take your request into consideration and we will notify you in case of any updates.
Please let us know if you have further questions.
Best Regards,
Vera
⋅ June 12, 2019
Any update on this feature?
⋅ June 12, 2019
Hello,
Thank you for your question.
We would like to point out that our roadmap is full at the moment.
We will notify you in case of any updates on the matter.
You are welcome to contact us in case any further questions arise.
Best Regards,
Vera
⋅ June 13, 2019
Hi,
Can you confirm that the Calculated values is technically possible with Elasticsearch?
This feature is vital for our migration to Elasticsearch with flexmonster so it's important for us to understand whether the limitation is technical or a question of resources.
⋅ June 13, 2019
Hello, Jason,
Thank you for your response.
We would like to confirm that implementing calculated values for Elasticsearch is mostly a question of priority and resources.
Could you please specify which formulas you would like to use with Elasticsearch?
We are looking forward to hearing from you.
Best Regards,
Vera
⋅ August 24, 2019
Any update on this?
⋅ August 27, 2019
Hello, Jason,
Thank you for your question.
At the moment there are not a lot of requests for this feature and for now, we are gathering the desired requirements.
Could you please let us know if you have specific formulas in mind that you would like to use with Elasticsearch?
This will greatly help our team.
Waiting for your reply,
Vera
⋅ August 28, 2019
Hello Vera,
Follow an measure sample that i wish i could migrate to elasticsearch
"measures": [
{
"uniqueName": "Total",
"caption": "Total",
"formula": "count(\"USER_ENTRY_REGISTRY\")",
"individual": true,
"format": "integer"
},
{
"uniqueName": "Realizadas No Prazo",
"caption": "Realizadas No Prazo",
"formula": "(\"Total\"-\"Pendentes\"-\"Realizadas FP\")",
"individual": true,
"format": "integer"
},
{
"uniqueName": "Realizadas FP",
"caption": "Realizadas FP",
"formula": "if((\"Pendentes\" = 0) and (\"DOWN_DAYS\" < 0), count(\"USER_ENTRY_REGISTRY\") , 0) ",
"individual": true,
"format": "integer"
},
{
"uniqueName": "Pendentes",
"caption": "Pendentes",
"formula": "if( \"EXTR_DT\", 0 , count(\"USER_ENTRY_REGISTRY\")) ",
"individual": true,
"format": "integer"
},
{
"uniqueName": "Pendentes FP",
"caption": "Pendentes FP",
"formula": "if((\"Pendentes\" = 1) and (\"DOWN_DAYS\" < 0), count(\"USER_ENTRY_REGISTRY\") , 0) ",
"individual": true,
"format": "integer"
},
{
"uniqueName": "Realizadas Pendrive",
"caption": "Realizadas Pendrive",
"formula": "if( (\"DATE_LOAD\" < \"EXTR_DT\") , 0 , count(\"EXTR_DT\")) ",
"individual": true,
"format": "integer"
},
{
"uniqueName": "Realizadas CNM",
"caption": "Realizadas CNM",
"formula": "if( (\"DATE_LOAD\" < \"EXTR_DT\") , count(\"DATE_LOAD\") , 0) ",
"individual": true,
"format": "integer"
},
{
"uniqueName": "Pendrive %",
"caption": "Pendrive %",
"formula": "\"Realizadas Pendrive\" / \"Total\"",
"format": "percent"
},
{
"uniqueName": "CNM %",
"caption": "CNM %",
"formula": "\"Realizadas CNM\" / \"Total\"",
"format": "percent"
},
{
"uniqueName": "B x R",
"formula": "1-\"Pendentes\" / \"Total\"",
"caption": "B x R",
"format": "percent"
},
{
"uniqueName": "B x R No prazo",
"formula": "(\"Total\"-\"Pendentes\"-\"Realizadas FP\")/(\"Total\"-\"Pendentes\"+\"Pendentes FP\")",
"caption": "B x R No prazo",
"format": "percent"
}
]
}
⋅ August 29, 2019
Hello, Mario,
Thank you for providing details on which formulas you would like to use.
We have studied the provided list of formulas and noticed that some of the formulas contain "individual": true.
This means that such formulas require raw data for calculation.
Currently, for Elasticsearch data source, Flexmonster loads already aggregated data (not raw data) for achieving better performance.
Because of this, it is not possible to implement calculated values with "individual": true for Elasticsearch.
However, we would like to bring to your attention that our team is working on the upcoming major release version 2.8 of Flexmonster.
This major release version will include a custom data source API, allowing you to implement any desired formulas.
Please contact us in case of any questions.
Best Regards,
Vera
⋅ November 23, 2019
Hi,
I've taken a look at the beta on github for custom data source and I see aggregations but nothing specifically about formula (e.g mathematical operators).
Please can you confirm if the full formula functionality in the component will be supported with custom data source?
⋅ November 26, 2019
Hello Jason,
Thank you for writing.
We do realize that the support of formulas is very important for the new custom API data source. Some of our users will not be able to migrate without fulfilling that need.
Currently, the formula functionality is already in priority in our list, and it is highly possible that it will be included in the release version. Still, our dev team requires more time to make a proof of concept and be sure that there are no pitfalls. We have noted your company as interested in this feature and we will keep you updated on the progress.
Please let us know if you have any other questions.
Regards,
Dmytro
⋅ November 27, 2019
Hi,
Thanks! Please do keep us informed.
⋅ January 28, 2020
Any update on implementing formula functionality for Elasticsearch or for the new custom API data source?
Regards,
Jaco
⋅ January 29, 2020
Hello,
Thank you for contacting us.
We would like to kindly inform you that calculated measures are going to be available for the custom API data source in the upcoming major release this February.
We will keep you posted with any updates.
You are welcome to contact us in case of additional questions.
Best regards,
Illia
