I've reclassified this as an idea. How would you envisage providing the data for the dynamic range? Picking another field, and using the sum/mean of that field? A formula-driven dial view is another possibility, where you enter 3 formulae (with the same formulae restrictions as in the Content view) which determine the needle, min and max values.

If would be useful to get dynamic range values as well.

A formula-driven solution would be fine especially in those cases when the calculation is too complex to simply use a value of a field.

Thanks Thomas

I haven't found a way to do this yet, so I don't know if its a new idea or just my lack of skill.

My file has 94 records. Each record has a column label at Level 3 (94), a group Label at Level 2 (28) and a further group label at Level 1 (4). I have been aggregating and disaggregating totals quite happily so far.

The 94 records have a range of values from 1 to 280.

I have set up the dial so that any one of the individual 94 values will show on a dial, within the range for all 94 values (Level 3). However, it would make more sense for me to be able to show a value against a dial range that reflects the associated grouped values (Level 2 or Level 1) for that record.

Can't see how to do this using either dial controls or filters. Is it possible?

Martyn - Like most other Omniscope Views, there is an Aggregation (not Grouping which is only available in the Table View) drop-down available in the Dial View. Open a Table View below the Dial View and choose fields to aggregate by to see what happens as you aggregate and change the aggregation functions for each field in the Table View. Apply the same settings to the Aggregation drop-down in the Dial View, and then change the value field the Dial View is displaying, and the function being applied to the Dial View value field. If you apply aggregation in the Dial View at Level 2 or 1, and set the function in the Dial View value field appropriately, the dial range should reflect values which have been aggregated.

I will try that, thanks.