Visokio website     Downloads     Video tutorials     KnowledgeBase  
Date/Time formats: Aggregate/split Date/Time fields by quarters? - Visokio Forums
Date/Time formats: Aggregate/split Date/Time fields by quarters?
  •     naruemon July 6, 2012 1:04AM
    Do we have the option to aggregate date/time field to be quarterly? - Thanks
  • 1 Comment
  •     tjbate July 6, 2012 2:11PM
    Mon - You can always use a second formulae field to 'bucket' each row by quarters, then aggregate/split by the formulae field specifying which quarter each row is in.

    The Bar/Line View will allow you to Split by a histogramed aggregations/splits of Date/Time fields using Fit to screen > Fixed interval size and setting the interval to 3 months, but this will not correspond to calendar quarters, just arbitrary 3 month periods of time.

Welcome!

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

Sign In Apply for Membership