try something like this, maybe:
UPDATED
index=MYINDEX source=MYSOURCE
| eval Day = strftime(_time,"%F")
| eval DateTime = strftime(_time,"%Y-%m-%d %H:%M:%S")
| stats Latest(LogType) as status Latest(Result) as Result Latest(DateTime) as When by PackageName ,ExecutionInstanceGUID, Day
| sort When
| streamstats count as "Execution Nr" by PackageName, Day
| sort - When
| table When, PackageName, "Execution Nr", status, Result, ExecutionInstanceGUID
| eval AlertLevel = case(Result=="OK",1,Result=="WARNING",2,Result=="KO",3)
| rangemap field=AlertLevel low=1-1 elevated=2-2 severe=3-3 default=guarded
| fields - AlertLevel
|appendpipe [stats count by ExecutionInstanceGUID | join type=outer ExecutionInstanceGUID [
search index=MYINDEX source=MYSOURCE
| rename ExplodedPackages{}.Error AS Error, ExplodedPackages{}.Package AS Package, ExplodedPackages{}.TimeStamp AS TimeStamp
| eval x=mvzip(TimeStamp,mvzip(Package,Error))
| mvexpand x
| eval y=mvzip(ExecutionInstanceGUID,x)
| mvexpand y
| eval z=split(y,",")
| eval ExecutionInstanceGUID=mvindex(z,0)
| eval TimeStamp=mvindex(z,1)
| eval Package=mvindex(z,2)
| eval Error=mvindex(z,3)
| table ExecutionInstanceGUID,TimeStamp, Package, Error]]
|stats values(PackageName) as PackageName by ExecutionInstanceGUID Error
... View more