Hi team,
So currently we are working on a custom dashboard in which there will be three columns, two of which are tags that we are setting and one will be the count.
Lets say the columns are Product, Intent and Count
Now how we want to display it is that for each combination of Product and Intent, the count should increase, i.e. we want to group by product and intent
Like for example if user selected Product A and Intent B and another user selected product C and intent B then table should be like :-
Product Intent Count
A B 1
C B 1
But it is currently coming in a different format
Product Intent Count
A 1
C 1
B 2
In my select query I am writing messageTag.product as Product, messageTag.usecase as Intent, count(sessionId) as Count
And in group by I am writing messageTag.product, messageTag.usecase
Is there any way to achieve what I want here ?