How to count names and show the result in a chart?

[vinicius.tst.eng]

hello everybody!

I am trying to build a chat where the equals names (which come from a database recorded by the user, I mean, the entrance depends on the user. He has a list of options to choose), are shown only once. So we will see for example, ˜Comunicação"= the sum of the entries.

Can someone help me out? I am really struggling with this.

Thank you everybody.

[chad]

Best way to achieve this would be by using the Grouped by feature
It is a little complicated but there is plenty of info here

[New Feature] Grouping and Aggregating Data

Hi all, We’ve heard from many of you that you’d like an efficient way of displaying your app’s data in a chart or table. For instance, maybe you’d like to be able to show a graph of new user signups by month, or show a table of total sales by region and account. We now have a tool for supporting this kind of operation. It’s called “:group by”, and you apply it on top of a search or other list of data items in order to group and summarize the list. [group%20by%20screenshot] The basic conce…

[vinicius.tst.eng]

Thank you very much Chad! This really solved my problem!

You are the best!

Cheers

[chad]

All good
Mark it as solved if you get a chance

[vinicius.tst.eng]

I will do it!

I made a question about a chart plugin, could you help me to solve the issue?

Set colors by categories

Hello bubblers! How are you guys going? I am currently using the plugin “Line/bar Charts” and I would like to know if there’s any way to define which color will appear in the chart according to the category. For example: Red for Unsafe, Green for Safe and Yellow for Improvements. I am really struggling with this issue. The colors are completely aleatory, I need to set the colors as said above. [image] [image] Does anyone can help me with this? Thank you very much!!

Thanks