Modal Average Function
-
I can't see a function for calculating the modal average, is there another way of doing this in omniscope please
Thanks
Steve -
2 Comments
-
Steve- can you send us an e-mail with more detail on the calculation you are trying to do?
-
Steve, thanks for pointing out this omission. "Mode" is now available in the latest daily build of Omniscope 2.5. It evaluates to the most common value for the field.
Its behaviour for exceptional cases is intended to mirror Excel's, as:
- If the field is multimodal (e.g. 1, 2, 2, 3, 3), then the first mode is the result.
- If the field has no variation (e.g. 1, 2, 3) then NULL (no value) is the result.
Welcome!
It looks like you're new here. If you want to get involved, click one of these buttons!
Categories
- All Discussions2,595
- General680
- Blog126
- Support1,177
- Ideas527
- Demos11
- Power tips72
- 3.0 preview2
Tagged
To send files privately to Visokio email support@visokio.com the files together with a brief description of the problem.