Hi, I need some help.
I have data that involves colors. For example, imagine I have a table with the following structure:
| ItemId | Color | Color_Code_Hex |
|---|---|---|
| 189987dfs897shs9df | White | #000000 |
| s98dfb7bsd87f687sd | Black | #FFFFFF |
| 8df786gd87f6g8d7f6 | Red | #FF0000 |
I would like to plot a bar or donut chart where we count the unique ItemId’s per Color, and I want each bar/slice to be painted in its corresponding color (so the count of Red items should be painted Red, and so on).
Is there any way to do this in Looker?
Thanks!