i have this type of table
time | apr1 | apr2 | ap3 | apr | may1・・・ | all period |
lineitem1 | 0 | 0 | 1 | 1 | 0 | 1 |
filter by allperiod | ✔ | ✔ | ✔ | ✔ | ✔ | ✔ |
filter by month | ✔ | ✔ | ✔ | ✔ | | |
if i use filter by allperiod = lineitem1[select:time.all periods],
i catch all data like not only apr data but also may date .
i want only apr data by day
i want to catch lineitem>0 only and aprs alldata
after filtering
apr1 | apr2 | apr3 | apr | allperiod |
0 | 0 | 1 | 1 | 1 |