I am using Elasic Cloud v7.5. I created two scripted fields. I am able to search and aggregate on the fields. I tried to transform to new index using the aggregate of scripted fields but the values are coming as zero in destination index. I used Create Transform UI in Kibana and tried to create the transform index. The destination index does not considering scripted fields.
Do we need to update the query in Advanced Pivot Editor?