Heatmap Tables & Column Sorting

michaelscott
michaelscott Member
in Archive

And probably for just regular "Tables" as well..

 

Not that im exciting to jump into looking at an Excel card within DOMO, but, how come there isnt a way to sort the column headers? or am i missing it?

 

Example:

 

I am creating a heatmap table with with 4 columns - Month, Requests, Leads, Cost

 

That is how i want them sorted - but the Table card automatically sorts the Column Headers in alpha. order so its Cost, Leads, Month, Request - this i dont want, but I cannot seem to find a way to sort them the first way and how I want them to be displayed.

 

Ideas?

Comments

  • Godzilla
    Godzilla Contributor

    When you Edit the card, on the bottom left side where the columns are listed, you can click on the little square icon in front of each field name and re-arrange the fields by dragging them up or down. 

    Domo Arigato!

    **Say 'Thanks' by clicking the thumbs up in the post that helped you.
    **Please mark the post that solves your problem as 'Accepted Solution'
  • nick_datasift
    nick_datasift Contributor

    I've run into this issue as well and have used a Beast Mode calculation as a workaround by assigning numbers to the text values in the field in the order I want them to sort. In your example:

     

    CASE WHEN `field name` = "Month" THEN 1

    WHEN `field name` = "Requests" THEN 2

     

    WHEN `field name` = "Leads" THEN 3

     

    WHEN `field name` = "Cost" THEN 4

     

    ELSE 5 END

     

    Field name in the back ticks is whatever the name of the field you are pulling in. Once you save this it will became a field available that you can bring into your report in the sort and will sort numerically in the order you assigned them.

  • kshah008
    kshah008 Contributor

    @michaelscott, did any of the above replies help address your question?

  • michaelscott
    michaelscott Member

    thanks for the replies!

     

    will check them out this week and post back.

     

    thank you

  • kshah008
    kshah008 Contributor

    @michaelscott, great! Please let us know ?

  • dbaydina
    dbaydina Member
  • kshah008
    kshah008 Contributor

    @michaelscott, hope you were able to work it out!

This discussion has been closed.

Categories