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
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.
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?
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.