Hi @bowesmana , Here is the query , and yes i have updated the sourcetypes but no luck: index=customdata | eval _raw="sourcetype,elementName,effective90Percentile" |multikv forceheader=1 | eval p90-01=if(sourcetype="Impala_NewWLM", effective90Percentile, null) | eval p90-02=if(sourcetype="Impala_OldWLM", effective90Percentile, null) | stats values(p90-01) as p90-01 values(p90-02) as p90-02 by elementName | rename p90-01 as "90th Percentile (Impala_NewWLM )", p90-02 as "90th Percentile (Impala_OldWLM )" elementName as Transaction Thanks, Vijay
... View more