Forum Discussion
Get data from another column for visualisation
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 |
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
I've found another solution and got it working - thanks for getting back.
2 Replies
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
I've found another solution and got it working - thanks for getting back.