Custom Dashboard - Number of queries in Label Chart

Problem Statement:

The config for the current issue in custom dashboard:-
Select : messageType as Messages, count(messageType) as Count
Filter By : messageType in (‘usermessages’)
Group By : messageType

Here when the chart is selected as table and previewed it shows 75 but when the chart is selected on “Label”, it shows “1” .
image

image

I would like to get the Label chart with the total bot conversation of 75 and not “1”.

Solution:

Label chart is useful when you want to know the no.of different labels.

In the scenario below we have two labels- ’ usersmessages ’ and ’ botmessages ’ for " messageType ". With the filter we further pulled only one of them - ’ usermessages '. Hence, the Label count is 1.

The value of Count is not what will be displayed but the no.of rows (let’s say) that are pulled for the query. So in our query count is aggregating the number of rows along with filter.

If we remove the count and use the query like below it will display data as per the requirement.

Eg:

image

Then the preview shows as:

image