how to I get dates on the x axis to order form Jan- Dec?

Comments

  • ckatzman
    ckatzman Contributor

    Add the date field that represents your X-axis value to the Sort criteria in edit mode, select Ascending, and depending on your card you'll need to determine whether it's No Aggregation or which Aggregation to use.  Most likely, No Aggregation.

     

    If the date value you are uising is not a Date data type, then you may want to consider fixing that through your data load process, or creating a Beast Mode calc using a CASE function to map Jan-Dec text values to a numeric sortable value, and drop that into the Sort criteria.

    **Say thank you by clicking the 'thumbs up'
    **Be sure to select the answer that represents the best solution and mark as "Accept as Solution"
  • Hi there!

     

    Thank you! So yes my Data isn`t date typed and cannot be due to the compariosn between 2016 and 2015 data. I was wondering if you could give a more detailed description on how to get beast mode to sort these values the way I am asking. 

     

    Thank you so much your help has been great thus far! 

  • ckatzman
    ckatzman Contributor

    Can you post an example of the format that your date field values are showing?  Do they look like properly formatted dates, but they didn't pickup a date data type during import, or are they representative of dates but not in a date format (ex:  20160720).

    **Say thank you by clicking the 'thumbs up'
    **Be sure to select the answer that represents the best solution and mark as "Accept as Solution"
  • If you're dealing with a handful (less than 20) labels, you can write a case statement in beast mode that orders them appropriately. For example

     

    case

    when `frustrating_date_field` = 'JanTwentySixteen' then 1

    when `frustrating_date_field` = 'FebTwentySixteen' then 2

     

    etc...

     

    end

     

    You can then sort on this beast mode (ascending) while leaving your date field in the x axis.

     

    On the other hand you can use the like function if you have too many labels to categorize one-by-one, but still have a pattern. For example

     

    case

    when `frustrating_date_field` like '%JanTwentySixteen%' then 1

    when `frustrating_date_field` like '%FebTwentySixteen%' then 2

     

    etc...

     

    end

  • kshah008
    kshah008 Contributor

    @rileyallison, tagging you to check out the latest replies.

This discussion has been closed.