How to customize data label in redash

[srikanthgarimilla1996]

In the above image, i have data in table format. I have selected pie chart for visualizing the above data. I have got the data in a pie chart. I wanted the list of users who have the respective log_status in data label. In the above image i was able to get only one user, How can i get list of users in the data label belonging to the respective log_status? Any help would be appreciated. Thanks.

[eradman]

The query would need to return the aggregate data

X Column: log_status Y Columns: user_id Data Labels: {{ usernames_by_log_status }}

The pie chart cannot apply a function to group values, so the database needs to sum this data