Segment on percentages

[#1]

Is there a way to segment on percentage values? Use case: I have a column with visits. I right click on it and choose Compare time periods -> prior month. As a consequence a third column appears automatically, alongside the new period compare column, showing the percentage change in the metric over the period. 

I would like to segment the table data by only showing rows in which the percentage change has been greater than 30%. How can I accomplish that?

[BernardoContopoulos · Accepted solution]

It's not supported at the moment. Vote for this idea https://experienceleaguecommunities.adobe.com/t5/adobe-analytics-ideas/metric-filters/idi-p/337724

---

Help make Adobe Analytics better, vote for the ideas too:

• Append variable name to the classification based dimensions in the left rail of Analysis Workspace
• Display Info icon on dimensions in the Segment Builder Definition area
• Line Visualization Setting: Display only dimension items in Legend
• Manage Projects: Search Reports by 'Shared with'

[BernardoContopoulos · Accepted solution]

OK, thanks

[BernardoContopoulos]

One option is to wrap the metric in both if and greater than functions, so that if percentage is greater than 30, return the percentage, else return zero.  You can then set the column settings to not show a value for 0.  This won't eliminate the other rows, but make it clearer to users about which meet that condition.

[BernardoContopoulos]

OK, that sounds interesting. OK, I found out how to edit the percentages. Need to make sense of the functions now. Greater than seems to only compare two different metrics. Need to investigate more. 

[ForgotPassword4Times]

You can put the percent difference calculated metric within the greater than field.

[BernardoContopoulos]

Thanks, I've managed to make this work.