Date/Time: splitting/aggregation/grouping by?
-
Hi - I am trying to split/aggregate/group my data on Month Year (e.g. Feb 2012); but the [Date] column is currently also displaying Days (e.g. 17 Feb 2012). Is there any way to achieve this for the view splits; or do I need to create a new formula field/calculated column in the DataManager? If so, which formula is the best for that?
Many thanks! -
2 Comments
-
Zhou - Omniscope stores dates-times as continuous values, and you can change the way values are displayed in any given field (or duplicate the field and display the values many different ways) just by changing the Date/Time field display formatting, in this case from {dd MMM yyyy} to just {MMM yyyy}. If you then go to any View that uses Split-by:, and specify [Date] and 'Unique values' rather than 'Histograming', you should see the data split/grouped by month.
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.