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.
Regards,
Simon.
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:
Year(Date)Month(Date)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:
Trunc(Now-Date)