New Contributor
Posts: 1
Registered: ‎10-31-2017

Cloudera Search- Group and calculation

Hi Am trying to build a transaction Log Monitor using Cloudera Serach Functionality.


I have a source writing records into a Solr Index. Each transaction can have multiple records each stating satus and some details. 


I would like to group records by a field lets say Transaction ID. And show a field called time taken which will be difference between earliest and latest record. Status should be from latest record. Once i click on the Transaction it should show me all records. Then i can click on each record for details.


Any idea how to do so. Now i have created a Dashboard which shows all records but not any kind of grouping of Time calculation.