3 Replies Latest reply on Jun 14, 2017 3:51 AM by Yuriy Fal

    Custom Grouping of Dimension - not Date type

    Martin Dale

      Hi,

       

      I need to create custom groupings on a dimension which is not a time/date based value.

      In a similar manner that time/date can be grouped into week or month or quarter, I have noise and vibration data which is frequency based (1 to several thousand Hz) and I want to create custom groups to aggregate the measures against.  For example, I may want to average the noise level in 50Hz bands from 0 to 2000Hz, or in 1/3 Octave bands, or I might just want to leave the data in it's original form and look at a line plot across the full frequency range.

       

      Can anyone explain how I could go about this, I've looked around the forums etc but can't quite find what I'm looking for.

       

      See attached workbook for some sample data.