Discussions

Expand all | Collapse all

Flip Report, Transpose

  • 1.  Flip Report, Transpose

    Posted 10 days ago
    Trying to flip or transpose a table report. I have a simple one to many relationship and a simple table report but grouped by a date field - 'week'.

    I want to create a table report but one that is flipped horizontally with the child records appearing as rows instead of columns.



    ------------------------------
    Phelan
    ------------------------------


  • 2.  RE: Flip Report, Transpose

    Posted 10 days ago
    well, you could copy to Excel and then edit paste (all)
    then edit paste special transpose into a new sheet

    But other than that, wow, that is a hard one.

    ------------------------------
    Mark Shnier (YQC)
    Quick Base Solution Provider
    Your Quick Base Coach
    http://QuickBaseCoach.com
    mark.shnier@gmail.com
    ------------------------------



  • 3.  RE: Flip Report, Transpose

    Posted 10 days ago
    Tried to find how to do this everywhere but failing miserably. Hope this can be a native feature soon

    ------------------------------
    Phelan Sanders
    ------------------------------



  • 4.  RE: Flip Report, Transpose

    Posted 10 days ago
    Phil,

    It sounds easy but is actually a completely different report.   Excel makes it looks simple but the spreadsheet is not really a reporting system, we just make the cells line up to be pleasant on the eye.

    Do you have any BI/BA tools like Tableau or Power BI?  We can get the data out of QB and then put an embedded report from one of those into Quick Base.

    ------------------------------
    Don Larson
    Paasporter
    Westlake OH
    ------------------------------



  • 5.  RE: Flip Report, Transpose

    Posted 10 days ago
    I was leaning towards MS BI and Tableau actually. Will have to see if it's doable.

    ------------------------------
    Phelan Sanders
    ------------------------------



  • 6.  RE: Flip Report, Transpose

    Posted 10 days ago
    Quick Base reports are fast and really easy to build, but when you hit the limit you are in real pain.   Reach out if you want to talk about doing a SQL Extract and connecting either of those tools. 

    Once you have BI, the sky is the limit.  However they are not as fast and easy as QB.

    ------------------------------
    Don Larson
    Paasporter
    Westlake OH
    ------------------------------



  • 7.  RE: Flip Report, Transpose

    Posted 10 days ago
    Phelan,
    I have not thought this through completely, But it seems to me that we could come up with a formula URL button combined with an automation which would copy the data from your original table into a temporary table for reporting purposes. The URL formula but would wipe the data in the target table and then will trigger a series of automations Steps  would run Saved table to table imports.

    ------------------------------
    Mark Shnier (YQC)
    Quick Base Solution Provider
    Your Quick Base Coach
    http://QuickBaseCoach.com
    mark.shnier@gmail.com
    ------------------------------