Get Free Trial
Get Free Trial

Calculated values will be avaiable for Elasticsearch?

MARIO FRANCESCO VALENTINO CORREA CAVACIOCCHI 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.

14 answers

Public
Vera Didenko Flexmonster 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

Public
Jason Whetton June 12, 2019

Any update on this feature?

Public
Vera Didenko Flexmonster 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

Public
Jason Whetton 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.

Public
Vera Didenko Flexmonster 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

Public
Jason Whetton August 24, 2019

Any update on this?

Public
Vera Didenko Flexmonster 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

Public
MARIO FRANCESCO VALENTINO CORREA CAVACIOCCHI 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"
}
]
}
Public
Vera Didenko Flexmonster 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

Public
Jason Whetton 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?

Public
Dmytro Zvazhii Flexmonster 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

Public
Jason Whetton November 27, 2019

Hi,
 
Thanks! Please do keep us informed.

Public
Jaco January 28, 2020

Any update on implementing formula functionality for Elasticsearch or for the new custom API data source?
 
Regards,
 
Jaco

Public
Illia Yatsyshyn Illia Yatsyshyn Flexmonster 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

Please login or Register to Submit Answer