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 ...
Forum Discussion
Tried to find how to do this everywhere but failing miserably. Hope this can be a native feature soon
------------------------------
--------
------------------------------
--------
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
------------------------------
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
------------------------------
- I was leaning towards MS BI and Tableau actually. Will have to see if it's doable.
------------------------------
------------------------------- 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
------------------------------- MarkShnier__You
Qrew Legend
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
------------------------------
