This should be a simple search to find the age of unresolved help desk tickets. I'm new to splunk thus there may be a better way to to this. I simply want to display the results in a simpleResultsTable on a dashboard using advanced XML except I can't get "myField" to show up in a SimpleResultsTable. Any thoughts?
Actually, this appears to give the results I'm looking for:
sourcetype=Remedy_Tickets | transaction ID CreateDate | where eventcount=1 AND QueryType="CREATED" | eval dur=round((now() - CreateDate)/60/60/24, 1) | stats values(ID) as ID, values(Group) as Group, values(dur) as Days | sort CreateDate