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.

9 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

Please login or Register to Submit Answer