Hey guys,
I Need to create a PowerBI Matrix visualization, which should present number of issues that contain column AND row count value.
I'll explain:
In the following snapshot, you can see how my DB looks like (on left side): 'issue_id' and 'tags' (which present the issue tags) fields. each issue_id can contain multiple tags, which concatenated with | sign between them.
I Should create a matrix viz, that present the number of issues that contains both of groups with AND between them.
For example, Tier 1 (first row) and Payer (first column) should count the number of issues from DB that contains tag 'paid' AND ('x' OR 'y' OR 'z', enough one of them).
The tag search in string must be equal! ticket_id 1599 which contains 'paida' is not equal to 'paid' so I have to find exactly the tag that I search for.
Thanks so much!
I Need to create a PowerBI Matrix visualization, which should present number of issues that contain column AND row count value.
I'll explain:
In the following snapshot, you can see how my DB looks like (on left side): 'issue_id' and 'tags' (which present the issue tags) fields. each issue_id can contain multiple tags, which concatenated with | sign between them.
I Should create a matrix viz, that present the number of issues that contains both of groups with AND between them.
For example, Tier 1 (first row) and Payer (first column) should count the number of issues from DB that contains tag 'paid' AND ('x' OR 'y' OR 'z', enough one of them).
The tag search in string must be equal! ticket_id 1599 which contains 'paida' is not equal to 'paid' so I have to find exactly the tag that I search for.
Thanks so much!
