Charts with Dates in Glide

[qb15]

I believe this is an ‘unworkaround’ scenario, but thought I’d post in case I’m missing something/ and someone has found a way around this.

Situation:

• Bar Charts in App with Date based values (i.e. LABEL/ X-axis is date)
• Charts has quantity on Y-Axis

Issue:

• Dates don’t line up on x-axis (e.g. missed dates aren’t shown/ they aren’t displayed as dates/ more just a ‘category’)
• Each bar is a different color because it treats each date as a different category ( unless it’s the same day)

Need:

• create a true time based chart

[SantiagoPerez]

Hola @qb15

Have you tried using Quickchart.io?

Quickchart.io: the Cloudinary of Charts —on the fly charts!

GAME CHANGER! Stumbled upon this site today—a way to create on the fly charts using data from your Glide tables. Images render instantly and you can select one of 14 different charts, customize colors, styles etc all through URL parameters! The video below shows my first attempt to create a chart from scratch and implement it in Glide. Took me less than 5 minutes. End result: [Screen Shot 2020-09-17 at 10.10.46 AM]

[PabloMFalero]

You can also embed charts from Google sheets…

[qb15]

We embed Google Data Studio charts to bypass the issue. From what I’ve seen better than google sheets. But it’s not ideal.

In GDS, you can define the user/ parameters for the chart - in googlesheets I’m not sure you can.

[qb15]

Awesome - this looks like the hack I was looking for. Thanks!

[cnaull]

Hello, I’m having a hard time understanding what I might be doing wrong.

I have (almost) the same chart in two different pages.

Chart 1 = weight monitoring of a group of athletes and Chart 2 = data from one athlete in their profile page.

For Chart 1, the x-axis (date) appears, but for Chart 2, it just doesn’t - whatever I have tried (and yes x-axis is checked on the right)
What can cause this?
The only thing I can see is in one graph, the filter is selected to chose the athlete, where in the second chart, it is not.
Any help would be appreciated, thanks!

Chart 1: (select from filter)

[cnaull]

**Chart2: (user data) no x-axis appearing **

[ThinhDinh]

Can you show us how your data is constructed for both these charts?

[cnaull]

Hi, Chart 1 (with x-axis showing) is from and Excel spreadsheet sync in OneDrive (ISAK Men)

[cnaull]

Chart 1:

[cnaull]

and then Chart 2 is from the same data source (ISAK Men) but filtered to only the User profile

same settings:

***oops, because I am new, I cannot reply more or update more screenshots…

[ThinhDinh]

So they are from the same table, just differed by the filter for the signed-in user?

Does it show the correct data time-wise? I mean does it work correctly in the second chart, just without the X-axis labels?

[cnaull]

Hi, yes there are from the exact same table.

The graphs are both the exact same in terms of visual, but the x-axis needs to show for graph 2 (when it’s filtered for one athlete on their profile page)

I also just tried adding the same Chart 1 to the Profile page - not filtered to the athlete (showing all data from the ISAK table) and the x-axis is still not showing.
So there seems to be something about graphs on the User page/Profile page vs other pages.
maybe I should report a bug??
thanks for your help

[ThinhDinh]

That’s weird.

Glide Pages Charts

Yes, you can activate the filter on the chart, as I did here to exclude any readings not in the current year (current year here is a field I hard-coded as 12/31/2021): [image] In your case, whatever field is your y-axis should be filtered to only include weights lower than what you want the maximum to be.

Per this comment, it seems like the filter does work with David’s test.

I would suggest contacting the support team.

https://glide-help.zendesk.com/hc/en-us/requests/new

[cnaull]

Thanks for your help, will do that!