Hi,

The challenge is centrally around calculating the “Total” row in a Table view. Not always the metrics are “totalled” using the functions built into Omniscope, so we use “formula result”. For that to work properly, especially with ratios, we need to choose the grouping option “calculate formula result over group result values”. Whenever the users switch to this, all the fields on which the calculations are based have to be made visible in a table view. That is not desirable from a dashboard design POV.

Anybody else faced/solved this? It would be really helpful someone could share the best way to handle this.

Cheers!
Indranil