MEGA TRICK: Dashboard design — Two columns, smaller charts

P.S. For the frugal ones — this is also a way to conserve object count, lol.

The sub-views don’t count as views towards the doc size limit. The whole dashboard counts as just one object and one row :rofl:

@shishir hint hint again that object count limit makes no sense :wink:

9 Likes

Excellent hint, @Paul_Danyliuk! :grinning:
I’m amazed and I’ll try to do some experiments very soon.
Great tip!

However, I believe that a free floating layout to build up a dashboard is definitely something that - better sooner than later - should arrive from Coda.

5 Likes

Seriously awesome approach @Paul_Danyliuk! and @Francesco_Pistillo.

2 Likes

Thank you @Paul_Danyliuk

Great to start my week with such a masterpiece :sunny:, it gives me the opportunity to learn something new.

Kudos :diamond_shape_with_a_dot_inside:to @Francesco_Pistillo, as you see you have been an early with your implementation" and we didn’t recognize the value of your work created.

2 Likes

Guys, @Paul_Danyliuk @Jean_Pierre_Traets
Thank you very much for the credits :slight_smile: … I wasn’t expecting that an innocent trick I made half a year ago would have gained so much attention…
Collaboration and recognition are two aspects that make this community super awesome!
Thanks again @Paul_Danyliuk for bringing this back. I’ve been using this approach for some time now and it works…it has some limitations though and I’m keen to wait some announcements from Codas about free layout in Canvas :grimacing: :grimacing: :grimacing:

4 Likes

Updated the sample to not require a [manually created] derived aggregation table of salespeople and gender — implemented the aggregation within the Leads table, so that when new salespeople are added, there’s no inconsistency risk. It’s not great data design, but a trick with its benefits and tradeoffs:

Hey Paul (or @Francesco_Pistillo), this is a great trick! One “off-label” use I tried for this was to embed a Todoist.com URL into a field. Using the width and height parameters, I can force the Coda field to expand to incorporate the site in the Table format (or in the Canvas of course), but that doesn’t work in the Detail format (even in Style 3). I queried Coda’s support team and they confirmed it’s not currently possible but they’ll add as a feature request. Do you have any ideas or suggestions for a potential workaround (somehow tricking the field container to expand) to make it work in Detail? Thanks!


JB

I can make the field container expand by concatenating the iframe with a tall Rectangle() — however it doesn’t make the iframe taller (it just lingers in the bottom of a tall wide field). Seems like the iframe’s height is just fixed in layout view.

UPD: @John_Beaudoin_Jack Found the trick, lol:

  1. Put a tall embed into a dedicated table
  2. Look up that table into your Detail view. Display it as a table.
  3. Hide all the table decorations
  4. Profit:

Your best gratitude for this trick would be rejecting Todoist and giving Three.do a try :upside_down_face:

2 Likes

Thanks for trying, Paul. I’ve also managed to achieve the desired result by using two tables on the same section. The first – in Detail Format – displays all the row’s fields except the embed. The second is a one-row, one column table containing the embedded URL. Using the interactive control I can keep them in sync… Inelegant, but functional for the time being.

Hey @John_Beaudoin_Jack — I updated the answer (you probably didn’t see it because only the first version got sent by email), and I actually did find the solution. See the community post. There’s a video too.

1 Like

AMAZING! How did you think of that approach? I’ll give it a try – and I’ll check out Three.do, too!

1 Like

Just thought that since embed looks fine in a table, why not put a table in a table :slight_smile:

image

That’s what I usually do. Just like here. Make assumptions, try combining stuff together, most of the time it works as planned.

2 Likes

@Paul_Danyliuk :point_down: looks like you have a budding Youtube channel
https://www.youtube.com/channel/UCu0vVBha0wHtouwSGyMhuEQ :+1:

  • recommendation: as you make your Youtube videos, adding the Discourse URL to the Youtube video description will help others connect to the context behind your genius
  • no need to be so hard on yourself. You are already doing 80% of the work for blog posts here in Discourse. Just take your favorite posts from this community and paste them [without editing] into http://codatricks.com/. Even if you never “have time to finally author it” you will still have the best Coda blog on the internet.
2 Likes

Nah, the channel’s just a dump, don’t bother :slightly_smiling_face:

Thanks @jeo! Regarding the blog, it’s my perfectionism that kicks in. However you’re right — I’m posting a lot on the community lately as a way to get that first draft out.

3 Likes

I have done this for my sprint stats but I found that interactive filter doesn’t work until I go to layout edit and back (even with no changes) - filter just don’t update! image I have this kind of filter for my charts and when they are pasted in Detail View like described above - the filted doesn’t work

Yeah, this is a bug, I reported it to Coda a few days ago.

In my dashboard sample, the control for pie chart affects the column values, not the filter. I think there may be some workaround but I haven’t looked into that yet.

UPD: The workaround would be to add a column to your sprint’s table that would simply pull the value from the select from your dashboard (e.g. same value for all rows if all you need is just a count), then make your chart dependent on that value. Then it will re-render when the select is changed:


image
image

Updated the sample in the original post with this workaround.

Sure, here:

1 Like

This is great! I’m getting stuck at the very beginning though. I created a Dashboard table in tables mode. For the first column, I want to see my Checkout Status Chart. I don’t know how to pull in the chart. I’m getting just the status that power the chart (e.g. Available, Not Available). How do I get the table into the cell?

You’re pulling row references, right? And the column is of type Lookup, allow multiple values, and the correct table? Then you should see the Table toggle as in my previous reply in this thread.

@Paul_Danyliuk why not making a Coda instead of a newsletter :thinking: