Merge/Group rows based on metrics

Logeshwar

I am trying to merge/Group rows based on metric range.

Present format

Desired format

Turribeach

Add a Prepare recipe and create a new houses_group column using a formula as follows:

if(cars > 1, "Houses with more than 1", "Houses with 1 car")

Then on the resulting output dataset add a Group By recipe and group by houses_group.

Logeshwar

Thank You