Hi,Another question. Is it possible to have two lines in a graph? 1st line of #cases of a specific day and a 2nd line of the average cases of the days in the data set?

Hi Gabriella,

This is possible, the question is not very clear however I will try to answer the best I can.

The first step will be to not create filters and use CASE WHEN statements to achieve the same, let's say you want the count for November and the average for November and December.

I would take the Dimension as Months and create two KPIs as follows.

Count for November

SUM(CASE WHEN MONTH = "November " THE 1 ELSE 0 END)

Average for November and December

AVG(CASE WHEN MONTH IN ("November ","December") THE 1 ELSE 0 END)

Hi Gabriella,

If I understand your question correctly, the answer is yes. But it depends on where you are creating the chart.

If it is in Process Analytics/Analysis you can create a maximum of 2 lines in the same chart using the Secondary Axis option (here you can check it https://docs.celonis.com/en/charts-and-tables---settings.html#UUID-ad50c78f-fdba-2008-4377-f6f9555e3677_id_ChartsandtablesSettings-PrimarySecondaryvalueaxis).

If it is a chart from a View , you can create multiple lines in the same chart. These are the steps:

1. First we create the Chart object within the View
2. Inside the configuration screen, we look for the Chart Layers option, from here we can add the different graphics that our Chart will have.
3. Select the Add option next to the Chart Layers title and select the type of chart, in your case the type is Line.
4. Next, we open the x and y axes tab and place respectively the dimension and the kpi corresponding to the first line.
5. Repeat points 3 and 4 for the second line of the chart.

I hope this is helpful.