I’m using the Chart Beta, in Stacked Bar mode, to display my stock of wine bottles, per vintage and color
I have in X Axis the vintage years as defined per my database values (number entered by user, converted to date)
In Y Axis, I sum up the stock of bottles per color of wine
It appears there is an issue with the values at the X Axis borders. Typically, in my data, I have a stock of 2 bottles of Champagne, vintage 2018. It is the youngest vintage for Champagne I have. But when I display the vintages per year in that chart, for my Champagne bottles only, the year 2018 does not appear in the X Axis, which stops at 2017. Any idea of what’s happening?
The original column is a Number-type one. Then I translate it in a Template-one, which I transform into a date through a Text to Date column. My constraints driving this approach :
I want the user to only have to fill a year, not a full date, when adding a wine to the database
I found the Number as the best way to do it
I need the vintage to be a date value, so that in the chart, the X axis does properly display all the years, including the ones with no stock
I think the way of converting that is bringing problems to the table because originally it’s not a true date object per se, and I’m not sure if the chart sees your “Text to Date” column as date also.
I don’t have a good workaround for you. Does this also mean if you want stacked bars of different wines in the same year, you also need to input them as different columns on the same row, opposed to multiple rows with a single “stock” column?
To my understanding, the chart does see my column as a date. Because date-related options for X Axis appear when I select it as X axis, and don’t when I select another column.
This is in fact what allowed me to truly have years in X axis, including empty ones. As opposed to when I chose the Number column (original user entry), I only get the years where there are values: the numbers are not considered as years.
As per your question for the rendering of stacked bars, not so sure to have understood it. But what I get is what I want : all colors are stacked into one bar for the same year (see below).
Is it possible to allow me to access the app and let me know how to navigate to that screen? I think it’s better to take a direct look at the data source. You can share an invite link through DM.
Yes, I’ve been using the new chart component quite a bit lately and it has serious issues displaying any computed values from glide big tables. Does that happen to be the case for you?
The case here was something wrong with the beta chart’s “year” version (it displays other years without problem but refuses to display the last one in Thomas’ database). He was using Text to Date for the value that the chart works with.
