Forum Discussion

Qrew Cadet

5 years ago

Flip Report, Transpose

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 ...

reports and charts

MarkShnier__You

Icon for Qrew Legend rank

Qrew Legend

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
------------------------------

Qrew Cadet

5 years ago

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

------------------------------
--------

DonLarson
Qrew Elite
5 years 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
------------------------------
- Del
  Qrew Cadet
  5 years ago
  I was leaning towards MS BI and Tableau actually. Will have to see if it's doable.
  
  ------------------------------
  
  ------------------------------
  - DonLarson
    Qrew Elite
    5 years 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
    ------------------------------