Hi all,
I have made a calculation to assign colours to a report based on value, percent of total. However, when I use this field by dragging it onto the colours shelf it's assigning multiple values, instead of just one. Below is another view of the data which illustrates this better - in this screenshot the actual 'percent of total' figure is the sum of the bits broken down into different colours, I have also added my calculated to the screenshot - can anyone tell me what's happening here?
Hi Ben,
Issue is that the color assignment is happening on you record level. Now, when you placed it on the view, it spreads it because each record has different percentages and therefore different colors on the same dimensions. Try aggregating them by getting average. Also, change the percentage to continuous instead of discreet.
Thanks,
David
