How do I add a stable total for other dynamic data sets to depend on?

[minkim1]

Currently I'm working on a new dashboard with set of data which gets updated twice a week filtered for unhealthy devices.

The total row of devices would equate to about 30,000, and only about 10% of this total are the filtered unhealthy devices.

On this dashboard, I'm trying to track the % of the total unhealthy devices decreasing over time with a new set of report being added twice a week.

However, working with the total device report without the unhealthy ones pre-filtered means I will be adding on about 30,000 rows of data twice of week, and I don't think that's scalable in the long run.

What I want to do is add a stable total of this 30,000 devices (since this count doesn't change all that much) from another simple Excel spreadsheet to my dashboard and allow other data sets to depend on it.

Below is the ideal tracking chart that I have in mind:

Device Groups	Date	Total Devices	Unhealthy Devices	%
Group 1	5/1/24	30000	3000	10%
Group 1	5/3/24	30000	2700	9%
Group 2	5/1/24	10000	1000	10%
Group 2	5/3/24	10000	800	8%
Group 3	5/1/24	5000	500	10%

So the total devices would come from a stable set of number for each device group which gets updated infrequently and manually, while unhealthy device counts will be updated twice a week.

Is this something possible for me to achieve?

Currently, I know how to add a stable set of data as mentioned above, but the data sets are independent of each other if they were used on a same chart like the Pie Chart: a new total is displayed (30000 total devices + 3000 unhealthy devices) and that's an incorrect representation of the data that I have.

I'm not sure if I explained my situation properly but let me know if I can clarify or elaborate anything. Thank you, in advance.

[Greg_Deckler]

@minkim1 Sure, just create an Enter Data query, 

Group1	30000
Group2	30000
Group3	10000

[minkim1]

Hi Greg,

I apprecaite the quick response. However, when I Enter Data to do what you've suggested on your reply (let's call it Group Total), if I were to use it on a chart along with my Unhealthy Device total, the two data would be completely independent of each other.

On the pie chart, it would show:

Group 1 Total: 30000

Group 1 Unhealthy Device: 3000

Chart Total: 33000

[Greg_Deckler]

@minkim1 You would create a relationship between the two tables based on Group I would imagine.