This topic contains 7 replies, has 2 voices, and was last updated by 
-
Posts
-
Hi,
I have a chart showing a sum of entries by status in a column chart.
I want to have the categories shown in the legend to be along the x axis but can’t figure it out, it only ever shows a numeric scale.Any suggestions?
Attachments:
-
You must add a screenshot of your chart config (basic setup tab where the fields are selected) and also a line from your datasource so I can see how the values look like in the fields you use in the chart.
Alexander
-
Will do tomorrow when I get into work.
-
Here is the info you requested
-
The second column must be specified as “String” and not Number – it isn’t a number and parsing it as a number will fail. If you use “String” it will be counted as 1 if the column is not empty, and as 0 if it is empty.
Alexander
-
I’m sure that I’ve already tried that, I’m not at work at the moment to try it again, when I did that the grouping count doesn’t work and I get hundreds of small bars instead of the few distinct groups.
-
I see, just change order of the fields in the chart config so the one using the title is the first column.
Alexander
-
I eventually got it to work …. sort of, I now have a chart with the right labels but I had to get rid of the ‘split options in separate series’ on the status column but not the ‘colorByLabel’ option no longer works =, I can live with that though.
Attachments:
You must be logged in to reply to this topic.