1st questions. What do you mean by cross the data? Like take data from one index and divide it by data from a different index? That should be possible.
2nd question: Add "q=" to your query.
.es(index=bi-experiment*,q='affiliateData.website:xyz.com',metric='sum:commission')
