Visokio website     Downloads     Video tutorials     KnowledgeBase  
Weekday order bar view - Visokio Forums
Weekday order bar view
  •     Maty January 20, 2012 9:27AM
    Hi!
    I am splitting my data by weekday in a bar view. My weekday is formatted as a date.
    My goal is to order the bars in a weekday order: Mo, Tue, Wed….
    How do I achieve it?
    Thanks, Matylda
  • 4 Comments
  •     tjbate January 20, 2012 10:42AM
    Matylda - There are two ways to do this, depending on the data typing of the field you want to employ in the Bar View. Try it both ways using duplicates of your imported [Date/Time] field:

    Leave one duplicate field typed as Date/Time and change the display format to: EEEE or EEE. This will display only the day of the week for each Date/Time value. Omniscope knows how to order these, so ordering the Bars by this field should show the correct sequence.

    Another way is to change the display format of a duplicate field to EEEE and then change the typing of the field to be text Category. By default, Omniscope will order these text values alphabetically, but you can set the sort order for the 7 weekday values from Data > Manage Fields > {Field} Options > Set value order.

  •     tjbate January 20, 2012 10:49AM
    All of the Date/Time field/column save and display formatting options are documented here:

    http://www.visokio.com/dates-and-times
  •     Maty January 23, 2012 10:25AM
    Hi Tom,

    Thanks for your support. I know "the dates and times formatting" and I have tried the first alternative. It did not work for me. I will send you my file via email, maybe it is the 2.7 alpha version?

    The second way worked well, thanks a lot.

    Matylda
  •     tjbate January 24, 2012 4:47AM
    Matylda - Thanks for your sample file. There is indeed a technical issue with displaying ordered days of week in bars when the x-axis is a Date/Time field. We are looking at fixes.

Welcome!

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

Sign In Apply for Membership