recently making an app using the free version on amCharts and Chart Element at the moment, i have got the expression to work for the category but for the value expression i cant seem to get this to calculate/count a list of items (i.e. Pending, Pending, Pending, Cancelled, Rejected should be Pending = 3, Cancelled = 1 and Rejected = 1) text field at moment, can you please help and advise.
I have managed to get this working but it does not Group the Categories.
hi @mm6som - it’s possible to group categories within the free plugin, it’s just a bit more clunky. You will need to apply a :group by… to both the category expression and the value expression.
Yes, :group by… works with text fields. The feature is native across Bubble and you can find more on it here. Anything that you read on that thread can be used within your charts - just remember (with the free plugin) that you need to apply to the grouping to both you category and your value expressions.
You are using Bubble’s own chart plugin here, not amCharts. This thread is for a different tool.
You are using :count which will not work with any type of chart. :count counts the number of items in a list to produce a single number - charts will need a list of numbers to work.
There are good examples in the thread that I shared previously (here) of how to use Bubble’s own charts with the :group by… feature. If you are still not able to work it out then I would repost your issue in that thread.
Did you take a look at the example that I created for you of how to use ‘count’ with amCharts? It is linked above. If you recreate that with your own data then you should see the result that you want.
I did but it still wont let use count with text field to count the numbers a particular thing is typed in.
below is the information as followed by your example version
Hello everyone, I want to display the last date in the (X) axe of amChart plugin because it doesn’t always display the completion date. anyone of you has a solution for it?
Down below a picture to explain the main problem
@exception-rambler I am trying to sign up for the premium version and not able to. I purchased ChartTools previously but not able to do 3 series area charts. I think I need amCharts premium to do that. Is this correct? If so, how do I sign up. I click to purchase premium from your website and it takes me back to the ChartTools page that I have already purchased.
Hello mate,
I need to show some stats in my app which are as following and I have no idea how to:
Show the occupation rate for a certain month. I have bookings which have a data set which is a date range, and I want to know how to group all bookings from a certain month and show the occupation rate;
Hi - sorry for slow response.
The plugin is bought via the Bubble marketplace - you do this from in-app. It’s called Chart Tools though and you should check the other thread for it: Chart Tools Plugin
You are right, you can do 3+ series in Premium… if you do subscribe I would recommend using the ‘Chart Tools’ elements as the code base behind them is more developed and better supported.
Hello @exception-rambler , I really like the plugin, thank you for making it available
I’m running into an issue with the amCharts Line element. I am unable to add a balloon label to my chart.
I cannot get the chart to display the point value. I tried setting “Balloon labels” to on and played around with different HTML in the text box, but nothing’s working -_-
@exception-rambler It seems that the amCharts element is not recognizing any mouse action over the chart.
Range selector, download and “chart by am chart” work and are clickable, but bubble doesn’t seem to recognize even clicks on the chart area (the actual line graphs).
Any way you could look into this as it’s a real braking bug?
I am using the charttools plugin. The chart doesn’t display the last bar on the right. I have tried to add padding to it but it still doesn’t appear. When I mouse over the last gridline (see below) the tooltip appears but not the bar. Any ideas>