Status Report / Table

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

Best Answer

  • Jim B
    Jim B
    Answer ✓

    Thanks, Paul. Appreciate the suggestion.

    Best,

    Jim

Answers

  • Paul Newcome
    Paul Newcome ✭✭✭✭✭✭

    Have you checked out Card View?

    thinkspi.com

  • 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
    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.

    thinkspi.com

  • Jim B
    Jim B
    Answer ✓

    Thanks, Paul. Appreciate the suggestion.

    Best,

    Jim

  • Paul Newcome
    Paul Newcome ✭✭✭✭✭✭

    Happy to help. 👍️

    thinkspi.com