How can I join same data in dashboard using arcade expression?

[RAMON_VERANO]

Hi everyone, I'm kinda new is ArcGIS online, I have some queries about dashboard and data expression.

I want to combine the data of each hazard so that I can count the total of each hazard but I don't know how can I do it because when I open the New Data Expression, it says that "This profile does not have any variables."

Here's the data I want to combine and seperate from other hazard.

[BlakeTerhune]

I think the GroupBy() function is what you want. There are some examples in the documentation.

[RAMON_VERANO]

Hello Blake,

I can't find the documents regarding the groupby function but will try to check other resources.

Thank you

[JohnEvans6 · Accepted solution]

There's a more in-depth discussion here with example code that seems? like it's what you're looking to do

arcade-expressions/dashboard_data/SplitCategories(PieChart).md at master · Esri/arcade-expressions ·...

[RAMON_VERANO · Accepted solution]

Thank you for this solution, I already solved it.