Need A Chart To Show Percentage of the Total # Of Features by Year Filter

Question

I'm building an EB dashboard to track power pole inspections. I currently have inspection year filters on the data. I'm trying to set up a dynamic chart to show the percentage of poles inspected each year. The problem I'm running into is that the filter only shows the total number of poles for that specific year. So on the chart I see the percentage of 109 poles inspected for 2023, but I want to see the percent of ALL poles inspected in just that year. I'm at a loss of how to set this up with the chart widget. In screenshot 1 below, it says that 100% of 109 poles were not inspected in 2023. In screenshot 2 the 2023 filter is turned off and you can see the percentage of total poles, 2874. So what I want to see is 109/2874 or roughly 4% for 2023. The client needs to inspect 10% of their poles each year, and keep track of that with this dashboard. Is this possible with the chart widget?

Laura · Answer

Here’s an example of how I handled this in dashboards for inspections:

I created a view table in Pro that contains only the most recent inspection for each hydrant. This keeps the data one-to-one and prevents older inspections from years ago from being displayed. The city has 1,345 hydrants total.

I set a filter where Inspection_Date is not null, which gives the count of hydrants that have ever been inspected. If you want to filter by a specific year, you can add an expression such as Inspection_Date between 01/01/2025 and 12/31/2025, combined with an AND statement.

For the gauge, I manually set 1,345 as the maximum value, and the gauge automatically fills based on the number of inspected hydrants.

When I add a clause that states inspected_date is within the last 3 months this is what it would look like:

To make it a % go to gauge and check 'as percentage'

You may be able to get to this result in EXB but dashboards offer more flexibility so I prefer to do it there.

Levi_Ethan_Cecil · Answer

.

Levi_Ethan_Cecil · Answer

I suppose disconnecting the chart from the filters makes sense. I was working on making a chart in a Dashboard for embedding, but I'm having the same trouble.