Skip to content

    • Archive

    Archive

    Pivot table type view

    Contributor
    in Archive

    Is there a way to have a pivot table-like view in Domo (that sums up columns and rows)?  Our users predominantly use iPads and my understanding is that sumo cards don't work on the iOS app.  We currently use heat maps to get our variances, but one drawback is that there is no total by category.  Is there any other card type that can replicate this functionality?

    Welcome!

    It looks like you're new here. Members get access to exclusive content, events, rewards, and more. Sign in or register to get started.
    Sign In

    Comments

    • Domo Employee

      @tleong,

       

      Sumo cards are the primary method for replicating pivot like views, but you are correct they aren't supported currently on iOS app. 

       

      One solution to consider would be creating a Magic ETL job using the Uncollapse Columns component which will group rows into columns...so essentially you could munge the data into columnar summaries and then use a standard table card with the Total/Subtotal feature to be summaries by column (https://knowledge.domo.com?cid=etlactionseditcolumns)

       

      Does this help?

      Jacob Folsom
      **Say “Thanks” by clicking the “heart” in the post that helped you.
      **Please mark the post that solves your problem by clicking on "Accept as Solution"
    • Contributor

      Is there a way to get this type of functionality in a heat map?  Currently, we use the heat map so we can drill into more detail.  If we followed your suggestion, would we still be able to drill-through on a table's row/column intersection?

    • Domo Employee

      The biggest difference when drilling into a table versus a heat map is that drilling into a table will only apply one filter.  Drilling into a heat map typically applies two filters.

    • Contributor

      We definitely want two filters.  Is it possible to get totals on a heat map?

    • Unknown
      Unknown

      Currently, Sumo table is the best option for replicating Pivot table functionality.

      Yes, you cannot see Sumo table on iOS. 

      Please submit an enhancement request via Feedback. 

       

      Thank you, 

    • Member

      @tleong,

       

      Please click on "Accept as Solution" on any reply that may have solved your problem.

      Thanks!

    • Unknown
      Unknown

      We were running into a similar problem over and over, so we decided to publish our fix as an app in the app store. If you search RXA in the app store it will pop up.

       

      A few more details here:

      https://dojo.domo.com/t5/Appstore/Pivot-Table-App-In-the-App-Store/m-p/30764

       

      --J

    Welcome!

    It looks like you're new here. Members get access to exclusive content, events, rewards, and more. Sign in or register to get started.
    Sign In

    Welcome!

    It looks like you're new here. Members get access to exclusive content, events, rewards, and more. Sign in or register to get started.
    Sign In

    Quick Links

    Categories