google sheetsgoogle-sheets-charts
It looks like bar charts in Google Sheets won't support percentages.
Is this correct?
If so, how would a change the populating query that currently returns "count of"?
A single cell used as the chart data source is currently coded:
=iferror(query(indirect(NDati&"!"&B2&":"&B2),"SELECT COUNT("&B2&") where "&B2&" like '%"&ITA&"%' label COUNT("&B2&") '' "))
That is is returning
Indeed, one cannot put things like "A6" inside the query string because then it would just a part of a string, not a cell reference. Instead, concatenate the value of the cell to the string:
=JOIN(", ", UNIQUE(QUERY(A2:F4, "select E where day(A) ="&day(A6))))
You don't need transpose, because join works equally well with one-dimensional arrays of either direction: vertical or horizontal.
That said, I find a solution using filter slightly more readable:
=join(", ", unique(filter(E$2:E$4, A$2:A$4 = A6)))
If the sort of chart you would like is as shown, then a change in layout might be advisable:
Best Answer
Bar charts can have percentages. In the example below, the numbers in the % columns are decimals that have been formatted as percentages, for example, 0.5 is displayed as 50% after applying the format.
If you are starting with a count, you need to convert it to a percentage by dividing by the total first. This cannot be done in the query. You must add another column that does the calculation.