Setup Multi Line Graph

Hello,

ok...multi line does work now and I am getting used to writing the SQL.

1. When there is no data in database for one line, it is still being drawn with 0 values for y-axis.

We can't hide empty data lines?

2. Is there a way to make the legend titles dynamic, using SQL?

In my case I am drawing 4 lines, but the data can change.

I would like to show in one case:

- company a
- company b
- company c
- company 1

In another

- company d
- company e
- company f
- company 2

3. I also noticed, when I add a title for x-axis, my x-axis values (0 -> 50) are hidden.

Is this normal?

thank you.

answer 3) I found the necessary setting "Give the horizontal start chart view and end chart view"...this will bring back the x-axis values

answer 2) I will name lines A, B, C...then I will show dynamic titles below chart with some coding. Should work for now, but would be a nice feature to create dynamic charts.

answer 1) If you want to ignore empty lines then put condition(WHERE column_name IS NOT NULL) in WHERE clause in your SQL query.