I have to basic tables example (as below). Would like to put in line graph General const over time, water cost over time, paper cos over time.
1. I found solution when I desciribe it in three different colums ("as Cost" as "Water Cost" as "Paper Cost") but is there possibility to create thee line only from column "as Cost" and somehow filter this ?
2. I would like to extract lines from charts only for some days with view that in not choosed day there is no line. Is there any possibility.
Thank you
| Time |
What |
Cost |
|
|
Time |
What |
Cost |
| 01.10.2021 |
paper |
5 |
|
|
01.10.2021 |
water |
3 |
| 02.10.2021 |
paper |
10 |
|
|
02.10.2021 |
water |
5 |
| 03.10.2021 |
paper |
12 |
|
|
03.10.2021 |
water |
4 |
| 04.10.2021 |
paper |
15 |
|
|
04.10.2021 |
water |
2 |
| 05.10.2021 |
paper |
21 |
|
|
05.10.2021 |
water |
8 |
| 06.10.2021 |
paper |
20 |
|
|
06.10.2021 |
water |
5 |
| 07.10.2021 |
paper |
22 |
|
|
07.10.2021 |
water |
4 |
| 08.10.2021 |
paper |
1 |
|
|
08.10.2021 |
water |
1 |
| 09.10.2021 |
paper |
2 |
|
|
09.10.2021 |
water |
2 |
| 10.10.2021 |
paper |
5 |
|
|
10.10.2021 |
water |
2 |
| 11.10.2021 |
paper |
4 |
|
|
11.10.2021 |
water |
5 |
| 12.10.2021 |
paper |
5 |
|
|
12.10.2021 |
water |
55 |
| 13.10.2021 |
paper |
88 |
|
|
13.10.2021 |
water |
2 |
| 14.10.2021 |
paper |
5 |
|
|
14.10.2021 |
water |
1 |
| 15.10.2021 |
paper |
4 |
|
|
15.10.2021 |
water |
3 |
| 16.10.2021 |
paper |
1 |
|
|
16.10.2021 |
water |
5 |
| 17.10.2021 |
paper |
2 |
|
|
17.10.2021 |
water |
4 |
| 18.10.2021 |
paper |
3 |
|
|
18.10.2021 |
water |
2 |
