# Best way to filter on trends in a chart

I have a chart with a very large set of series values. I want to filter to focus on members of the series exhibiting specific trends (uptrends or downtrends) based on the y-axis value. Does Domo provide any such filters? Or perhaps someone can recommend a Beast Mode calculation I can reuse?

• Coach Not sure if this is what you are going for, but I put together how to get the Top N of a Subcategory that may help you.

https://youtu.be/hfIUQqeRVkM

Hope this helps.

**Check out my Domo Tips & Tricks Videos

**Make sure to any users posts that helped you.
• Coach You could utilize a simple linear trend slope calculation however you wouldn't be able to do it in a beast mode because you'd need to aggregate some aggregations.

```sum((x−avg(x))*(y−avg(y)) )

/

sum((x−avg(x))*(x−avg(x)))
```

This will give you a larger number for faster increasing trend and smaller numbers for slower increasing trends. + values would mean the trend is going up, negative would be going down.

You'd need to use a window function to calculate your average across your partition for each row then use a separate tile to calculate the rest.

**Did this solve your problem? Accept it as a solution!**

• Coach Not sure if this is what you are going for, but I put together how to get the Top N of a Subcategory that may help you.

https://youtu.be/hfIUQqeRVkM

Hope this helps.

**Check out my Domo Tips & Tricks Videos

**Make sure to any users posts that helped you.
• Coach You could utilize a simple linear trend slope calculation however you wouldn't be able to do it in a beast mode because you'd need to aggregate some aggregations.

```sum((x−avg(x))*(y−avg(y)) )

/

sum((x−avg(x))*(x−avg(x)))
```

This will give you a larger number for faster increasing trend and smaller numbers for slower increasing trends. + values would mean the trend is going up, negative would be going down.

You'd need to use a window function to calculate your average across your partition for each row then use a separate tile to calculate the rest.