Discussions

Expand all | Collapse all

Flip Report, Transpose

  • 1.  Flip Report, Transpose

    Posted 02-07-2020 18:37
    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 02-07-2020 18:39
    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 02-07-2020 18:51
    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 02-07-2020 19:01
    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 02-07-2020 19:07
    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 02-07-2020 19:21
    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 02-07-2020 19:39
    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
    ------------------------------