Status Report / Table

Jim B

Hello, I am stuck with piecing together what I thought would be a simple visualisation.

I'm trying to build a report to go into a dashboard that shows the status of various projects in a table like this:

I need the columns across the top to run left to right in a specific order and beneath that I want my Project Names to line up in their 'buckets' by status underneath.

How best to achieve this with a chart or report that I can fold into a dashboard for easy sharing across the project?

As you might imagine my data is held in a typical grid with the Project Name in the Primary column and in another column I have Project Status as a field limited dropdown.

Hope you can help.

Many thanks,

Jim

Jim B

Thanks, Paul. Appreciate the suggestion.

Best,

Jim

Paul Newcome

Have you checked out Card View?

Jim B

Hi Paul,

Thanks for the response. Yes just like a card view.

Is there a way to incorporate the card view into a Dashboard?

Or is it possible to recreate the card view in the form of a report and display that in the Dashboard?

Best Wishes,

Jim

Paul Newcome

When you publish a sheet, there is a dropdown that should let you select card view. You can then use a Web Content widget on a dashboard to have it displayed there.

Jim B

Thanks, Paul. Appreciate the suggestion.

Best,

Jim

Paul Newcome

Happy to help. 👍️