Bug in Sumocard: date grain sorting... Sorting on date grain not working anymore..Can someone help?

user09879
user09879 Member
edited March 2023 in Datasets

Bug in Sumo card: date grain sorting... Sorting on date grain not working anymore..Can someone help? its urgent

 

Thanks in advance

Best Answer

  • DataMaven
    DataMaven Coach
    Answer ✓

    Here's the workaround we came up with for quarterly grain to come through in order:

     

    In ETL -

    Use datepart function to isolate year and quarter. 

    Combine year and quarter columns with Q as the character separating the values.  

     

    Because this results in a text output, it will sort properly by default.  

     

    Of course - we will all be thrilled when the official fix is deployed, but this can help anyone in an immediate bind.  

     

    DataMaven
    Breaking Down Silos - Building Bridges
    **Say "Thanks" by clicking a reaction in the post that helped you.
    **Please mark the post that solves your problem by clicking on "Accept as Solution"

Answers

  • Jarvis
    Jarvis Domo Employee

    Hello user09879,

    If you believe that you are experiencing a bug within Domo, I would advise that you get in touch with your Domo account team for support. Make sure to include the link to your card, and also any errors you are seeing.

     

    Thanks!

     

    Jarvis

  • user09879
    user09879 Member

    This is communicated to domo technical team as didnt receive any quick response here.. thanks for your reply.

  • DataMaven
    DataMaven Coach

    Your post doesn't really give enough information to hazard a solution.  If you don't quickly get a solution from support, perhaps you can post some screenshots or more information about the issue you are facing.  

     

    One thing that comes up a LOT is date format.  So - First thing is to make sure the date field is in date format.  If it was working before and suddenly isn't, it could be a format change from an iterative update or something. 

    DataMaven
    Breaking Down Silos - Building Bridges
    **Say "Thanks" by clicking a reaction in the post that helped you.
    **Please mark the post that solves your problem by clicking on "Accept as Solution"
  • James_Thoma
    James_Thoma Member

    I am having the same problem. I can sort dates, text, numbers, etc. But if I use a date grain I am unable to sort.

     

    Screen Shot 2019-02-20 at 12.37.27 PM.pngScreen Shot 2019-02-20 at 12.37.18 PM.png

  • DataMaven
    DataMaven Coach

    Is the field you're trying to sort in Date format or Text format?

    DataMaven
    Breaking Down Silos - Building Bridges
    **Say "Thanks" by clicking a reaction in the post that helped you.
    **Please mark the post that solves your problem by clicking on "Accept as Solution"
  • DomoRookie
    DomoRookie Member

    I'm having the same problem. I added a date grain to view by quarter but the quarters aren't in order. I'm sorting the rows by Total Commissionable Sale. I just want the date columns to be in order.

     

  • DataMaven
    DataMaven Coach

    Sort by Date then Sales.  If that doesn't work, do the opposite. 

    DataMaven
    Breaking Down Silos - Building Bridges
    **Say "Thanks" by clicking a reaction in the post that helped you.
    **Please mark the post that solves your problem by clicking on "Accept as Solution"
  • DomoRookie
    DomoRookie Member

    I've tried both. Didn't work. Any other ideas? 

  • DataMaven
    DataMaven Coach

    I can webex with you this afternoon and explore it with you, if you'd like.  What time zone are you in?

    DataMaven
    Breaking Down Silos - Building Bridges
    **Say "Thanks" by clicking a reaction in the post that helped you.
    **Please mark the post that solves your problem by clicking on "Accept as Solution"
  • user09879
    user09879 Member

    This is communicated to domo technical team as didnt receive any quick response here and they dont have any solution yet. thanks for your reply.

  • DataMaven
    DataMaven Coach

    @user09879 - I understand that you reported it, and that they haven't found resolution for you.  Others are having similar challenges.  Support not having a resolution does not mean that I will not be able to find one.  Would you prefer that the other users launch a new question so that you don't receive the alerts?  I'd like to solve this.  Thanks!

     

    @DaniBoy - What is your suggestion?  Should we split this out to a new question, or should I proceed with working on resolution?

    DataMaven
    Breaking Down Silos - Building Bridges
    **Say "Thanks" by clicking a reaction in the post that helped you.
    **Please mark the post that solves your problem by clicking on "Accept as Solution"
  • user09879
    user09879 Member

     Kindly keep it open. And I am sure the solution would be there and DOMO will do it but at times patience is too much challenged ? .

     

    Nevertheless kindly keep this story open. I dont mind receiving alerts.

    Thanks

  • DomoRookie
    DomoRookie Member

    That would be awesome DataMaven! I'm actually leaving on springbreak this morning. I'll reply again when I'm back in town and see if you can help me. I'm in the Mountain Time zone. 

  • [Deleted User]
    [Deleted User] Member

    Folks,

    Thanks for your patience here. This seems to be a known bug based on the earlier response from the support team in the thread. I will try and get an update on where Domo is in addressing this.

     

    In the future it is recommended that you provide as much detail as possible when posting questions so others can be better equipped to assist.

     

    Thanks!

  • user09879
    user09879 Member

    Dani is my boy. Thumbs up  ?

  • DataMaven
    DataMaven Coach

    Thanks @DaniBoy - In the meantime, I will see if I can help folks with a workaround.  Jugaad is my specialty!  ?

    DataMaven
    Breaking Down Silos - Building Bridges
    **Say "Thanks" by clicking a reaction in the post that helped you.
    **Please mark the post that solves your problem by clicking on "Accept as Solution"
  • DomoRookie
    DomoRookie Member

    @DataMaven  I still haven't found a solution. I'd love some additional help if you can fit me into your schedule. 

  • James_Thoma
    James_Thoma Member

    I thing I had to do was create a new field which took the date field and set the day to the first of the month. That way, all rows occuring in the month of october 2018 show up as 10/1/2018. That way I do not need to use the date grain and I can sort. 

     

    It stinks, but they are working on the bug.

  • [Deleted User]
    [Deleted User] Member

    Thanks everyone.

     

    We are about a month away from getting this fixed released to all. I will bump it up again to increase visibility but know that there is a lot of code from Domopalooza in our release in the coming weeks.

     

    Appreciate everyone's patience here!

     

  • DataMaven
    DataMaven Coach

    @James_Thoma - That's one of the things I do, too!  ?  

    @DaniBoy - Glad it's on the horizon!!!  (Patience?  I don't have patience...I have workarounds!)

    DataMaven
    Breaking Down Silos - Building Bridges
    **Say "Thanks" by clicking a reaction in the post that helped you.
    **Please mark the post that solves your problem by clicking on "Accept as Solution"
  • DataMaven
    DataMaven Coach
    Answer ✓

    Here's the workaround we came up with for quarterly grain to come through in order:

     

    In ETL -

    Use datepart function to isolate year and quarter. 

    Combine year and quarter columns with Q as the character separating the values.  

     

    Because this results in a text output, it will sort properly by default.  

     

    Of course - we will all be thrilled when the official fix is deployed, but this can help anyone in an immediate bind.  

     

    DataMaven
    Breaking Down Silos - Building Bridges
    **Say "Thanks" by clicking a reaction in the post that helped you.
    **Please mark the post that solves your problem by clicking on "Accept as Solution"
  • DomoRookie
    DomoRookie Member

    Thanks again @DataMaven! You were so helpful!

  • [Deleted User]
    [Deleted User] Member

    Thank you @DataMaven  you are a rockstar!

  • user09879
    user09879 Member

    Hello,

     

    This was suggested in the past as well. however I am looking for that thrilling moment when the then working feature in sumo card is back. I dont want to keep creating calculated fields for such basic feature. I have waited for long I will wait for some more. Thats okay. I am very content that you guys are on it.

     

    Best Regards

  • DataMaven
    DataMaven Coach

    @user09879 - The underlying issue and upcoming fix has been discussed and established. Excited for the fix, too!  

     

    There are still folks who need to make it work today, through a workaround, and need help.  That is what the community is here for.  Whenever there is a hurdle, even if Domo is working to smooth it, the user community comes together to help each other meet their immediate needs.  We just can't help ourselves!  ?

     

    Have a great day!

     

    DataMaven
    Breaking Down Silos - Building Bridges
    **Say "Thanks" by clicking a reaction in the post that helped you.
    **Please mark the post that solves your problem by clicking on "Accept as Solution"

Categories