Try something like this | makeresults format=csv data="no,item
1,A
2,B
3,C
4,D
5,E"
| append
[| makeresults format=csv data="date,item
2024/10/1,A
2024/10/1,B
2024/10/1,C"]
| append
...
See more...
Try something like this | makeresults format=csv data="no,item
1,A
2,B
3,C
4,D
5,E"
| append
[| makeresults format=csv data="date,item
2024/10/1,A
2024/10/1,B
2024/10/1,C"]
| append
[| makeresults format=csv data="date,item
2024/10/2,C
2024/10/2,D"]
``` The lines above represent your sample data appended together ```
| chart count by item date
| fields - NULL
| untable item date count