Delta of two dates across multiple documents

[kumpelblase]

I have an index with history-logs of a ticket. The mapping of that index looks like this:

> {                                
  	"mappings" : {                 
  		"ticket_history" : {         
  			"properties" : {           
  				"TTH_TicketNr" : {       
  					"type" : "integer"     
  				},                       
  				"TTH_Nummer" : {         
  					"type" : "short"       
  				},                       
  				"TTH_Benutzer" : {       
  					"type" : "short"       
  				},                       
  				"TTH_Datum" : {          
  					"type" : "date",       
  					"format" : "dd.MM.yyyy"
  				},                       
  				"TTH_Zeit" : {           
  					"type" : "date",       
  					"format" : "HH:mm:ss"  
  				},                       
  				"TTH_Aktionstyp" : {     
  					"type" : "keyword"     
  				},                       
  				"TTH_Ticketattribut" : { 
  					"type" : "keyword"     
  				},                       
  				"TTH_WertAlt" : {        
  					"type" : "text"        
  				},                       
  				"TTH_WertNeu" : {        
  					"type" : "text"        
  				}                        
  			}                          
  		}                            
  	}                              
  }                       

A ticket has allways multiple history-logs. I need to know if it's possible to calculate the delta of the first and last date of a ticket. So far, I managed to display th efirst and last date of a ticket, using a Kibana Data Table. Furthermore I need to calculate the average of the deltas.

This is what I allready could do:

[cjcenizal]

Hi there,

Unfortunately, Kibana doesn't currently support dynamic comparison between cells in a data table. I think what you're trying to do would be enabled by https://github.com/elastic/kibana/issues/5049 and https://github.com/elastic/kibana/issues/3620. You can subscribe to those issues if you'd like to track progress on this feature.

Thanks,
CJ