Best way to filter on trends in a chart

Dr_Duru

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?

MarkSnodgrass

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.

GrantSmith

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.

MarkSnodgrass

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.

GrantSmith

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.