I have a inserted the following bar chart into my Pro App
It displays perfectly well on desktop, in the editor and in the live website. However, when I view the App using my iPhone the chart does not display any bars (line) in the bar chart.
I have toggled the view between desktop and mobile in the data editor and it all works perfectly well there.
Here is a screenshot from my iPhone.
What column are you using to get the months? Is it “date format”?
No I use a long winded exercise of pulling apart today’s date MMM-Y and then use template columns and relations.
I extract the month number and use a maths column to get the last 12 months as 12 different rows. I then look up the respective month to replace the numerical number with an abbreviate month (Sep, Oct, etc…). I then stitch them together the year to reform 12 rows with format Jan-2023. I then use a Query (with filter by country) to relate each row to multiple rows in the data table to capture all entries inside the respective month. Finally, I use a roll-up to count the number of entries found by the Query…
Probably a horrible way to program but it works on desktop!
I am relating a template column with a formatted date column to capture the data… maybe Glide struggles with that for some reason. But works in Desktop.
Yes, that is pretty long winded
If I’m understanding correctly, the column you use to relate to your Data table is the “Template Finally month-1” column, yes?
What method do you use in your Data table to convert the dates into that “MMM YYYY” format?
Yep, embarrassingly long-winded. I searched for a way to do date maths but seems like subtracting a whole month is not easy either… hence my approach above. I also played with the new AI feature to generate a date from text but that seemed impossible.
The method for the table table is 1 step:
Okay, that’s what I suspected and is almost certainly the culprit.
The Format Date column is known to have issues with Safari on IOS and can return unpredictable results.
I recently did something very similar to this - are you open to a suggestion for a somewhat simpler approach? (one that will work on all devices)
Ok thanks for confirming. Perhaps I should convert the ‘Sep 2023’ column into a text column via a template? [I just tried this and it didn’t solve the missing line/bars in the iPhone]
And yes, would love to see a shorter route to this!! Thanks for offering…
No, I wouldn’t expect that to work reliably. What you could do for now is the following:
- Use a Math column to extract the Year from the Date:
- Use another Math column to extract the Month number:
- Convert the Month number to a short text description of the month name (I think you already have a method to do that?)
- Stitch the Year and Month name together in a template, and use that in your relation/query.
I would expect the above to solve your immediate issue.
I’ll try and make some time later this evening to describe the method I used. It involves a bit of fancy date math.
We have seen enough reports to see “Format Date” isn’t reliable at all for iOS.
Just got round to implementing your bullet points. It works in terms of identical behavior on desk top with the relation behaving as before and the charts displaying. However, on iPhone the issue persists: Line charts and bar charts don’t display the data. Interestingly, I added a radial chart and that works perfectly well on iPhone, which proves the relations are all ok. Seems to be Glide Glitch.
So you don’t use Format Date anymore and the issue still persists on iOS?
Can you try opening the Glide builder in Safari and see if any value is missing?
I’d be skeptical about it being a Glide issue.
So you’re absolutely 100% not using the Format Date column (or any other of the date related plugins) anywhere in the chain?
@Simon_Hill - I made a small demo App to satisfy myself that this should work on all devices. I’ve tested on IOS/Safari and it works fine.
Note that it uses the User Profile row, so you must be signed in for the chart to work.
Here is a template link if you would like to make a copy and take a look at the implementation:
Ok now it works on mobile too for all graph types. THANK YOU.
My bad. When Darren suggested using Maths columns to spilt and reform the date column, I applied that to the master data set only. Of course a relation has 2 fields, the field to match and the match options. I had only adjusted the latter.
With your last response, I realise the relation also starts with a field generated with use of a ‘format date’ column. I replaced that with the suggested maths column, e.g. month(now) and year(now). It worked first time.
The reason the pie chart was working is because it didn’t use the relation. It was looking at share of total rolled-up data and did not require the chart to be split by month-year (it’s a pie-chart!).
Again, thank you for your patience… appreciated.
I’m tripping on another issue, can you help?
I want a simple column where I can calculate how many days ago the Enrollment was made. I assumed the following maths column would work. But for some reason it does not express the answer in days but jumps to some strange format…
Any tips on why that simple time maths formula is not working please?
When you subtract one date from another, Glide will by default return the result as a duration.
To coerce that into number of days, use the following: