Hi, I want to show the elapsed time of each event return by my query . The elapsed time is on field name execTime, the event name on field Title. I used a bar chart stacked to show the result. My query is :  index=blabla | table title, execTime | transpose 0 header_field=title include_empty=true The issue is transpose command aggregate all title with the same value. I won't that. Before transpose I have this :  Title Duration T1 2 T2 5 T3 1 T2 6 T4 12   After transpose I have this (T2 is agregate with sum) :  T1 T3 T2 T4 2 1 11 12   But I want this :  T1 T2 T3 T2 T4 2 5 1 6 12   Regards ... View more

Hi, I want to show how many lines contains some value even if no line return. My data : Row 1 : F1: a Row 2 : F1: b Result desired on table : F1 => Nb a => 1 b => 1 c => 0 ... View more