Interactive Dashboard Pie Chart

Stacy1624

Does anyone know if I can build a pie chart that will adjust to a different months data with a dropdown in the Dashboard? I have a pie chart for level of service on a certain highway for a certain direction and shoulder per month. Instead of having 12 pie charts, one for each month, I was hoping to have a dropdown where the viewer can select what month they are interested in and the pie chart would update. Ideally the user could select multiple different items to filter the pie chart: Options being Highway, Direction, Shoulder, Month

MPath

Unfortunatly this is not a capability currently in dashboards.

Workaround would be to have filters that users adjust in the report you are using to feed the dashboard.

Andrée Starå

Hi @Stacy1624

I hope you're well and safe!

Unfortunately, it's not possible now, but it's an excellent idea!

Please submit this as a Product Feedback or Idea (If it hasn't been added already) when you have a moment.

I hope that helps!

Be safe, and have a fantastic week!

Best,

Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

✅Did my post(s) help or answer your question or solve your problem? Please support the Community by marking it Insightful/Vote Up, Awesome, or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!

MPath

by the way!

check this out: https://www.youtube.com/watch?v=S1aFvYJQzb8 In first part there is a possible solution for it, but it is not explained further. if youre more handy than I, you will probably get it.

@Andrée Starå will get it for sure.

Andrée Starå

@Stacy1624 & @MPath

I misread the question. I've actually developed something like this for another client. There are two options to solve it, both of which are fairly advanced.

• Submit the form to select the criteria, and refresh automatically after the form is submitted.
• Dropdown in the dashboard to select criteria, manual refresh

Make sense?

Which one would you prefer?

Stacy1624

@Andrée Starå

Thank you! I would prefer the second option listed - dropdown in dashboard to select criteria with a manual refresh. I found antoher Utube by Prodactive that may walk me through creating this. If you have guidelines that are easy to share I would appreicate them too!

MPath

@Andrée Starå Both are interesting, but somehow manual would seem more preferable to me.

Stacy1624

The link @MPath provided above was exactly what I was looking for and I created what I needed. Thank you both for the input!