Visokio website     Downloads     Video tutorials     KnowledgeBase  
Aggregation: Grouping records by date? - Visokio Forums
Aggregation: Grouping records by date?
  • nicci113 May 17, 2013 6:09AM
    Hi,

    Is there a way to group dates within Data Manager? I'm creating a primary key, but need the group function ?
  • 4 Comments
  •     tjbate May 17, 2013 7:00AM
    Nicci - Do you mean you want to evaluate a date/time value for each record, and based on the interval classify/'bucket' the record with a category value for each interval?

    If, so this is a new formula field you can add in the Field Organiser block that 'buckets' each record, as exemplified here:

    http://www.visokio.com/kb/useful-formulae
  • nicci113 May 17, 2013 7:06AM
    29-Apr-2013 00:00:00
    30-Apr-2013 00:00:00
    03-May-2013 00:00:00
    03-May-2013 00:00:0

    In this example,I want to merge the similar dates together and all the results associated to it.. like we do in pivot when we group the date its that logic I need at this stage. I tried to use the pivot block, but it doesn't pick that logic and was wondering, if some other block/formula can be used.

  •     tjbate May 17, 2013 7:09AM
    As long as you are careful to standardise the formatting in the whole field, this should be an Aggregation block
  • nicci113 May 17, 2013 11:02AM
    Thanks!

Welcome!

It looks like you're new here. If you want to get involved, click one of these buttons!

Sign In Apply for Membership