Counting Job Metro IDs with Revenue Greater Than 1 Million

Monika [1:24 AM] Hi all. Is there a possibility to count how many job_metro_id have revenue > 1M? In example below my expected result is 3.

Johannes K.
·
·
I think you can build custom properties that should help here: https://mixpanel.com/blog/introducing-the-mixpanel-modeling-layer/ I think you would want to use the value property and if that is > 1m, create a custom property that sets to TRUE. Then you can count or filter by that in your report.