Get data from another column for visualisation

[Will90]

Hi,

I have a simple table below which I am trying to get data from another column using the ID to show a visualisation.

So I want to get say ID 1 to show Down and 10 by using a red Donut with a Card showing the total in the middle.

Another showing a green Donut with a Card showing 100 in the middle for ID 2?

ID	Status	Time	Total
1	Down	01/10/2018	10
2	Running	01/10/2018	100
3	Down	01/10/2018	23
4	Running	01/10/2018	50
5	Running	01/10/2018	65
6	Running	01/10/2018	23
7	Down	01/10/2018	3
8	Down	01/10/2018	0

[v-yuta-msft · Accepted solution]

Hi Will90,

Based on your description, maybe your requirement is like below:

 

If you not like this, could you clarify more details about your requirement?

Regards,

Jimmy Tao

[v-yuta-msft · Accepted solution]

Hi Will90,

Based on your description, maybe your requirement is like below:

 

If you not like this, could you clarify more details about your requirement?

Regards,

Jimmy Tao

[Will90 · Accepted solution]

I've found another solution and got it working - thanks for getting back.