how to build an interactive dashboard

Hawk

If I have a dataset looks like below:

Project_ID  Approval_Status

    P1               Approved

    P2               Declined

    P3               In approving

    P4               Approved

 

is it possible to create an interactive dashboard showing the approval status of each Project ID? and Project ID put into a drop down frame on the left of the dashboard, user can select any of Project ID in the frame and view the approval status on the right in a text box.

 

sean59916

Not elegantly, no.

I have created something similar for a client with an intermediate step where the users selects the project ID on a sheet and then clicking on a url in that sheet to show the results for the selected project on a dashboard.

 

Sean

Andrée Starå

Hi,

Yes, there are a few different ways to do it. Here's one.

A sheet as a web content widget that is set up to with a drop-down with the projects and then that would show the approval status in the next column.

Would that work?

Have a fantastic weekend!

Best,

Andrée Starå

Workflow Consultant @ Get Done Consulting

Paul Newcome

I second Andree's suggestion. And to keep the dashboard looking a little cleaner, the URL Widget can be resized so that you can only see those two particular cells.