I need your help please, I have two tables resulting from two searches and I need to join these two tables to make a cumulative bar chart according to date.
My tables are
What I want to achieve is:
You have two different formatted tables. You might want to transform the structure either on first search or second.
first_search | join type=left Schicht_Datum [ second_search | untable Schicht_Datum segment mid_result ] | xyseries Schicht_Datum segment mid_result
Something like this:
<first table's search> | chart sum(mid_result) over segment | append [| search <second table's search>] | stats sum(*) as * by Schiche_Datum | rename Schiche_Datum as Datum
Kindly ignore typos and fix column names if I mis-typed it.
What are your two searches?