In the Series Category for zeroqodes bar chart, it requires a list of texts. I am trying to display data by Fiscal Week so I saved the week number as a text since no math is being done on the week number. but the plugin thinks it’s a number.
Is there a way to get around that without having to append “Week” to 48 to get to “Week 48”
I am using the premium version of the plugin.
Hello @chris.e.daly ,
Thanks for reaching out to us.
To begin, can you please confirm if you are referring to the Air Chart Pro plugin—the bar chart element? Indeed, for the categories field, you must have a list of texts, which is a basic type of field used in many elements from Bubble.
To troubleshoot this, could you please hover over the expression to see what kind of values the editor recognizes?
If they are numbers, you can use the expression “each item: formatted as…” so that the values you provide will be seen as a list of texts rather than numbers or other types.
Could you please check this on your end and let us know your findings?
Thanks, and we look forward to your reply.
Best regards,
Support Team
Browse all Zeroqode Plugins for Bubble
The data column fiscalWeek is a text but it has a number in it - so not sure if Bubble is just treating that as a number or not.
The series groups by fiscalWeek and used the eachitems fiscalWeek. I appended the formatted as which turned it to a list of texts but the data did not show.
I am attaching an image of what it looks like when I use a date (offerCreateDate) and formatted as mmm yyyy and that works fine.
I will take the query and pop it into an RPG to see if the query is pulling data.
This is the screenshot of the RPG with the formula grouping by fiscalWeek and showing the Average order Value (numbers are in cents, Shopify stores all currency in cents so I need to transform that to dollars still). The data is there and the grouping is working for the fiscalWeeks.
The little RPG on the left is the AOV by fiscalWeek.
Hello @chris.e.daly ,
Thank you for your message.
From the images you shared, it appears that the table where “fiscalWeek” is stored is called “Periods.” However, in the chart element, you are first performing a “Search for Offers…”. Could you please explain why you are referencing another database table and why you are using “group by…” in this context?
Also, if the categories field is of type text and contains numbers, it will still be treated as text, so there should be no issue using it. Could you try pointing directly to the “fiscalWeek” from the Periods table and let us know the result?
Additionally, could you show how you set up the repeating group you mentioned? What Type of content did you use there? Was it a basic type “text”?
Thank you, and we look forward to your reply.
Best regards,
Support Team
Browse all Zeroqode Plugins for Bubble
Yes - each offer has an offerData *the date a customer makes an offer" and that date is then matched to the date in the Periods table to pull back the FiscalWeek the offerDate ocurred in.
So if the offerCreateDate is today, 2024-11-07 then the fiscalWeek is 45 when I match offerCreateDate on Periods.date and return the fiscalWeek.
And yes - I will try that but I am displaying offerData in the chart, would not the offerCreateDate have to be connected to Periods to show offer data by period?
Hello @chris.e.daly ,
Thanks for your message.
Indeed, the Air Chart plugin works by getting a list of numbers in the “Series data” [a1, a2, a3…] and a list of texts [c1, c2, c3…] in the “Series categories”. The plugin does not modify them in any way but will simply display them in the chart in the exact order they are in the arrays: a1→c1, a2→c2.
To troubleshoot why it is not working as expected, please use ‘Inspect’ and ‘Step-by-Step’ mode to review the element and each of the actions performed on the chart. Check what data it is receiving and in what order it is present there.
Also, you can check our demo page editor to see examples of setting it up and our documentation here: Air Chart Pro: 182 Premium Charts Plugin for Bubble | Zeroqode
I hope this proves helpful. Please let me know if you have any other questions.
Thanks, and I wish you a great weekend ahead!
Best regards,
Support Team
Browse all Zeroqode Plugins for Bubble
Just an FYI - I resolved this by making some database changes so that the data is coming through as text. I also had to make some changes around dates for the periods to get it to work right but the chart is publishing fine right now.
Hi @chris.e.daly,
Thank you for getting back to us.
We’re delighted to hear that everything is working smoothly now. Please feel free to reach out if you need any further assistance—we’re always here to help and would be happy to support you. 
If you’re enjoying our plugins and have a moment to spare, we’d love for you to rate them. Simply go to the Plugins tab in the Bubble editor, search for the plugin by name, and rate it with the stars you think it deserves.
Additionally, if you’d like to share your full experience with Zeroqode, we’d be grateful if you could leave feedback at: Zeroqode Review. Here are some direct links as well:
Your feedback is incredibly valuable to both us and the Bubble community, inspiring us to continue delivering top-notch products and excellent service.
Thank you once again, and we wish you a wonderful week ahead. 
Support Team
Browse all Zeroqode Plugins for Bubble
