Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I want to apply threshold on each bands and want to show result based on threshold.
You can create the range labels by creating a table as follows:
Ranges:
Load <some unique ID>
if (Amount >=0 And Amount <=90, '0-90',
if (Amount >90 And Amount <=18, '91-180',
if (Amount >180 And Amount <=360, '181-360',
if (Amount >360, '>360')))) as Range
Resident DataTable;
In above example, you would have to create a unique key in your source data (row number would work) and use that key as linked field.