We’re trying to use Flexmonster with Elasticsearch for a sales report with current inventory level. For a specific date range, I want to take the sum of the sales in one column and the last inventory quantity as another column.
Is there any way to achieve this in flexmonster? I checked the calculated fields but I don’t see anything like Last. In elasticsearch the equivalent can be achieved with a Top Hit aggregation with the size set to 1.
Thank you for writing to us.
At the moment Flexmonster doesn’t support this feature.
However, we have added this request to our customers’ wishlist and we will notify you in case of any updates on the matter.
Please let us know if you have any further questions.