Dashboarding Options With Card Views

[Suvrutt_Gurjar]

Just thought of posting use of card views to make useful dashboard reports.

There are some challenges, but these are because of extending use of card views for dashboard purpose. The card views in themselves work nicely. Kudos to @morgan and AppSheet team for these versatile card views.

So I created a test app based on some test data. The below screenshot shows the card view in desktop mode from that test app.

Following services I used while creating teh test app-

1. Quickcharts for graphs - Thank you @tsuji_koichi and @Fabian for excellent inputs on charting servcies.
   Radial Gauge / "Meter" - Inline Dynamic Icon - How to create?

Observation: Only dial charts seem to render well. For bar , pie charts, trick for increasing the font of legends and pie/ bar values is required.

2. placehold.jp for cards having images with digits and small image at the top left in all cards ( Containing the report period “Jun 2020”). Again thank you to @tsuji_koichi and @Fabian for excellent inputs below

Add text as layer to Image - Free API service Tips & Tricks 💡

The new edge browser is actually Chrome… [image]

Observation: Text inside the placeholder image is of same size. Trick to vary font size , color and possibly include icons will help to create more meaningful main card images.

I was looking for creating some user friendly dashboards for some time. While participating in the post below, thought of using card views.Then added more options with above tips.

Customize My Dashboard Data for User Questions

In my google sheets I am able to produce some key metrics based on a query. These metrics include MAX value, % Change From Last, # of Days Ago, etc. These are simply numbers. Fortuantely, AppSheets can link up to my table that has all these key metrics. Is there anywhere in App Sheets that allows me to customize how this data will look in the app? So far, I see in the UX that DECK view is it; however this is not the best view. Is there anywhere else I can play around with how I can display thi…

The dashboard is rendered from a "presentation layer " table in the test app. The table is purely created to feed only the card view and has no other business logic in it.

While using the dashboard card views alongwith other app views, data from main app table will need to be massaged and put in to this “presentation” table for rendering through the dashboard.

Hope it helps and I am sure , community will come out with many more creative options.

**Edit:**Made some changes to the description to make it clearer.

[Grant_Stead]

@martin check this out!