I would like to automate my bar graph. Currently I’m creating a new line for each unique entry to the database. Is there a way to do this with some kind of ‘SELECT DISTINCT’?
An example of the first line is;
CASE WHEN COUNT() FILTER(WHERE TestView.category = ‘python_test_assert’) > 0 THEN COUNT() FILTER(WHERE TestView.category = ‘python_test_assert’) ELSE null END AS python_test_assert,
yes ! maybe you can try first basic color option like “classic palette”,
if it’s not working you can make value mapping,
if still not try to do this with override to target the right column