Hi,
Here's what I want to have in a DataTable visualization :
I'm using 2 scripted fields :
- 1 to get the value of column Date1
- 1 to get the value of column Date2
For my third column, I would like to use the values that I get in both columns and do another script to calculate the values (it's the working days between the 2 dates)
Can I do it with the scripted fields ? Because in painless language I only saw "doc["my_field"].value" but never "doc["my_scripted_field"].value
Is there a way to do it or am I doing it wrong ?