@torkel I have been using table plugin in grafana, I have a situation where there is a template variable “Version” with data V1, V2, V3 …etc. for every version, there is data and I am querying to get the total count of every versions data
V1 Total V2 Total A 10 A 20 B 20 B 15 C 30 C 25 X 5 Y 3 L 2 N 9
Since I am having template variable “Version” If I try combining two versions I get
V1+V2 | Total A | 30 B | 35 C | 55 X | 5 Y | 3 L | 2 N | 9
Basically In Lucene query, if I filter individually I get the output… but not possible to query for every data
( $version AND $data: "A" ) ( $version AND $data: "B" ) ( $version AND $data: "C" )
Any help with performing inner join using Lucene query were only common matching data between two versions are displayed and not others?