Question

You are building a report page that analyzes customer orders. The Order Amount column is a continuous numeric field ranging from $5 to $12,000. Stakeholders want to see the count of orders grouped into fixed monetary ranges of $500 each (for example, $0–$500, $500–$1000, and so on) on a column chart, without creating a new calculated column in the model. What should you do?

Accepted Answer

Right-click the Order Amount field, select New group, choose Bin type and set the bin size to 500.

Answer

Create a calculated column using SWITCH(TRUE(), ...) to assign each order to a $500 range.

Answer

Right-click the Order Amount field, select New group, and choose List grouping to select individual values.

Answer

Apply a Top N filter on the column chart to limit the displayed order amounts to increments of 500.