Drag-and-drop in Pivot tables

I've wished for a couple of different Kanban views that don't yet exist in Aha! and Aha! support has recommended I build a pivot table to at least get a static view of the Kanban I want.  Sometimes that static view is enough, but sometimes I really want to act on what I am looking at without having to open the drawer.

If I could drag-and-drop between columns in a pivot table (and perhaps also drag-and-drop to change the order of items within a column) I could build a dynamic Kanban of virtually any object/value pair in Aha!!

  • Peter Marshall
  • Jul 12 2016
  • Likely to implement
Release time frame
  • Attach files
  • Admin
    Chris Waters commented
    July 12, 2016 21:14

    Can you elaborate on which colums/rows you would like to see in a kanban board? This is something which has been in the back of our minds for a while, but there hasn't been another combination (beyond status/assignee) that has become a dominant request.

  • Peter Marshall commented
    July 12, 2016 22:39

    I'd really love a Kanban for Initiatives (as requested here).  But since we don't have that yet, I've built a Pivot table with Initiative statuses as the columns, Products as the rows, and cells made of the Initiative name and Initiative rank.  See attached (we call Initiatives "Epics").  I then sort by Initiative rank ascending.  If I could drag-and-drop in a Pivot table, then I could drag an Initiative...

    • from one column to another to change its status
    • from one row to another to change its product (unlikely)
    • within a cell to change its rank (this might not be possible since rank seems to be based on some combination of value and effort)

     

    I've also created a Pivot table for Features to try to work around the limitations of the Feature Workflow interface - I don't want the assignee swimlanes (as requested here) and I want to customize the "cards" (as requested here).  This table has the Feature statuses as columns, Products as rows, and cells made of the Feature name, Feature rank, and assignee.  I also have the Epic name added to the data set but not connected to a pivot table part; I use it to setup a "color by" in the table view settings.  Again, I sort by rank.  If I could drag-and-drop in a Pivot table, then I could drag a Feature...

    • from one column to another to change its status
    • but not from one row to another since Product is set at the Initiative level (so I set the row headers to swimlane style)
    • within a cell to change the rank

     

    The Pivot table feature, by the way, is awesomely powerful and a great addition to Aha!

  • Peter Marshall commented
    July 14, 2016 19:31

    correction for above comment:

    If I could drag-and-drop in a Pivot table, then I could drag a Feature...

    • but not from one row to another since Product is set at the Initiative Release level...
  • Admin
    Ron Yang commented
    July 22, 2016 00:23

    Thanks Peter. We appreciate the additional information to help us better visualize what you might be looking for. We've updated your idea to Likely to Implement, while also adjusting it to be most related to the Kanban board updates. 

    We're likely to make updates in that area though are unlikely to make specific updates to the Pivot reports (in terms of drag and drop capabilities there). As this idea progresses, we'll post status updates here.