📊 Has anyone figured out how to make a real dashboard [view all data]

[Curtis_Smith]

Something like this? Where charts are laid out in one glance.

Or can I send data from Coda to Sheets and embed the sheet?

[Denis_Peshekhonov]

To be honest, I came to Coda to make personal dashboard Like you showed. But I’ve found that it is almost impossible to do this without the Column Layout.

So, I decided to wait.

[Francesco_Pistillo]

waiting for layout in Canvas… I achieved a similar way with Layout in Detail View…
Basically I created a table with 1 row and several columns depending on the graphs/text you would like to have…

Each column has several medium/complex formulas that gets aggregate values from here and there (other tables). Then I switched the view from Table view to Detail View and… TADA… it works… of course it’s not ideal, but it’s acceptable…

[Paul_Danyliuk]

Mad thanks @Francesco_Pistillo for that post. I had to make a dashboard yesterday and remembered about your trick that I noticed half a year ago and then forgot.

I expanded this into a separate post:

MEGA TRICK: Dashboard design — Two columns, smaller charts

Here’s a mega trick how you can implement a gorgeous dashboard in Coda: [ezgif.com-optimize (57)] Create a table with a single row. Pull in all the data you need into columns. Each dashboard element (a chart, a table etc) — a separate column. By pull I mean either import the whole table or some filtered subset: [image] Make a Details view out of that table. Go to Customize Layout, and select Quick Style 3: [image] Quick style 3 has one big advantage: you can have two equally wide col…

[jeo]

@Curtis_Smith, @Denis_Peshekhonov, @Francesco_Pistillo, @Jerry_Zhang, @Sam_Giligich, @Veha_Suwatphisankij, @Kurt_Kessler, @Jami_Haavisto, @Stephan_Graf [and anyone else who reads this later]
Please click through to

(2021-04-22)

Coda seeking feedback on potential new feature!

Hey there! We’ve heard your feedback, and Coda’s product team is now exploring the possibility of a new feature: canvas columns . To explain it simply, this feature would allow you to position content side-by-side in the canvas. At this point, we’re still in the exploration phase and can’t make any promises. And should we be able to move forward with this feature, it will likely take time (don’t expect to see it launched in the next few weeks). But with all that said, we’d love to get some more…

[Alex_Whitton]

Agree template levels are quite good in Coda, but no inspired data dashboards to show data in a meaningful way

[Pch]

Well @Alex_Whitton , as announced few months ago during the last Block Party , we will soon have a very New Editor which will introduce a feature you might be interested in : Page Layout . It allows us to put content side by side… and can be used to create dashboard …

If you wish to test it out, you can request access to the Beta here

Announcement: New editor extended beta

Hi makers! Thank you to those of you that joined the new editor beta and gave us such valuable feedback. We are still working to ensure our new editor will provide the best experience for our customers and for this reason, we are extending our beta! Before registering please note: This beta includes access to page layout and canvas column; after careful consideration we decided to change the name of page layout, originally canvas layout, to align more with the feature functionality. If you op…

And if you want to know more about Coda New Editor and its features, you can take a look at this video Block Party 2021 | Behind the building block: A new editor - YouTube

[Alex_Whitton]

Thanks very much - but keen to see actual templates built so far, if anyone can recommend any that are duplicatable?

[Pch]

No problem @Alex_Whitton !

The feature is still in beta so it is recommended not to share anything publicly yet …

Nonetheless, as part of the upcoming Custom Pack feature (still in beta too), the great @Daniel_Stieber shared his Facebook Marketing Insights Demo Pack …
If you look at the doc he shared, the dashboard on the first page uses the Page Layout feature

Pack: Facebook Marketing Insights (Demo)

Hey, I’m currently working on a Facebook Marketing Pack, that helps to bring insights from Facebook & Instagram Ads into Coda. I made a little recording how it looks like and how to make a Dashboard within minutes with it: Facebook Dashboard DEMO · Jack’s Chewing Gums (DEMO) Watch Video [image] Here is the Jacks Chewing Gum Demo (open in coda for better view): Because the whole ‘Custom Packs’ program itself is in Beta right now, I can’t share it yet – but is anyone interested in getti…

[Susan_M_Davis]

I second @Francesco_Pistillo remarks. I made several dashboards where I created a dummy table then use different columns to pull in data, set some controls at the top that work to filter those columns and use those columns to display charts. Works great! Now…when column layouts arrive…I’ll want to rework several pages! It’s going to be FANTASTIC!

[Alex_Whitton]

@Susan_M_Davis Here is an excel dashboard I use (fake data) pulled from a custom web app grid to excel - puzzling and seeking the use cases for Coda but requirements are limiting unfortunately - will continue to play in Coda

[Susan_M_Davis]

I think you could do most of that in Coda. You’d have to have a table maybe several holding the data. Those blue boxes on the top left I’m assuming are buttons. You would make those select’s where the user chooses the items to be seen. That top information would be done by some formulas put right onto the canvas that are pulling in filtered data and doing some calculations. Then I’d have a filtered table view. Because of the width, you’d probably need to do sub pages to see all your data. The one limitation Coda has is that it doesn’t to wide beyond the page layouts very well. You could build a dashboard (dummy table with layout of multiple columns) but I suspect it would squish things to fit the page width rather than allowing you to scroll right to see the rest. But you could make each column of data a sub page and just click to see that information. All of it could be driven from the choices made on the main page.