I havedata like this , thiis is sample data i created, every time the data reload the data wil change i want to show the colrs in barchart will be sown in staright table as well, i dont want to be hardcode, everytime the data reload the Groups tickets aging will also change,
The below one is sample, actually there are large nof groups and everytime the data change the bars wil also change so we cannot hardode them..
I have taken dimensions as Group and Bucket and expresion as count( distinct (ticket))
in which i have hided the expresion , where can i keep the above function in my dashboard and also i have used persistent colors and used first , but i am not geeting the correct colrs after getting the output
Go to expression tab-->click on the + symbol before your expression it will show some options list like Back groud color ans text color,You just click on background color and paste Color(FieldIndex('Group',Group)) expression