How to regroup two graphs in one?

[clairebesson]

Hello everyone! I need to do something that I think is very easy. I have 4 graphs from 4 different sources. (4 servers).

In the first graph you can see how many devices are up and how many are down for server 1. In the second you can see how many devices are up and how many are down for server 2 etc…

I want to regroup my graphs on one in order to do something as the figure below.

I don't know how to do that because the data are in different sources ("server1.csv", "server2.csv" ...)
Thanks in advance for your help.

[fdi01]

try like:

...|timechart  span=1d count(eval(Status=="Up")) AS "Up" count(eval(Status=="Down")) AS "Down" by  source|eval source=if(source="server1.csv","server1",if(source="server2.csv","server2",if(source="server3.csv","server3","server4")))

[chimell]

HI clairebesson
Try this :

 |set union[search "server1.csv"| chart count(eval(Status=="Up")) AS Up count(eval(Status=="Down")) AS "Down" count(Status) AS Status_C count AS TotalC by source] [search "server2.csv"| chart count(eval(Status=="Up")) AS Up count(eval(Status=="Down")) AS "Down" count(Status) AS Status_C  count AS TotalC by source ]

[woodcock · Accepted solution]

Something like this:

... | chart count(eval(Status=="Up")) AS Up count(eval(Status=="Down")) AS "Down" count(Status) AS WithStatusCount count AS AllCount by source

[clairebesson]

It works ! Thank you very much for your help !
source=server* | chart count(eval(Status=="Up")) AS Up count(eval(Status=="Down")) AS "Down" by source

[clairebesson]

with your help I managed to get the chart above.
Now, I want to click on Up for server1 and go on other dashboard and do the same thing for Down:
- Click on Up Server1 --» go to dashboard1
- Click on Down Server 1 --» go to dashboard2
- Click on Up Server 2--» go to dashboard3
- Click on Down Server 2 --» go to dashboard4

For the moment I have :

      <condition field="Up">
        <link>
      /app/search/what__track_up_aps?form.Up=$click.value$
    </link>
      </condition>
      <condition field="Down">
   <link>
      /app/search/what__track_down_aps?form.Down=$click.value$
    </link>
      </condition>
 </drilldown>

So, when I click on any column "Up" It goes to the same page (Same thing for Down).
I don't know how to make a condition on the source. (When I click on Up/Server1 it goes on dashboard1 and when I click on Up/Server2 it goes on dashboard2)
Could you please help me with that ? Thanks in advance for your help

[woodcock]

This is a totally different question and you should ask a new question like:
"How to control drilldown on dashboard chart clicks"