🍉 Meet Flexmonster Pivot Table & Charts 2.9.Check out all hot features!
Get Free Trial

Top Hit (last)

Jason Whetton asked on May 17, 2019

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.

1 answer

Vera Didenko Vera Didenko Flexmonster May 20, 2019

Hello, Jason,
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.
Best Regards,

Please login or Register to Submit Answer