# Bar Chart not displaying on iPhone device **URL:** \ **Category:** Report a Bug\ **Created:** [September 14, 2023, 7:40am UTC](https://community.glideapps.com/t/bar-chart-not-displaying-on-iphone-device/66130 "2023-09-14T07:40:43Z")\ **Posts on this page:** 20\ **Page:** 1
**Author:** ![Simon\_Hill](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/simon_hill/32/94730_2.png) [@Simon\_Hill](https://community.glideapps.com/u/Simon_Hill)\ **Post date:** [September 14, 2023, 7:40am UTC](https://community.glideapps.com/t/bar-chart-not-displaying-on-iphone-device/66130/1 "2023-09-14T07:40:43Z")
I have a inserted the following bar chart into my Pro App ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/d/6/d6635660c740b6f041e214141e3b4a5dc6b225c0.png) 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. ---
**Author:** ![Simon\_Hill](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/simon_hill/32/94730_2.png) [@Simon\_Hill](https://community.glideapps.com/u/Simon_Hill)\ **Post date:** [September 14, 2023, 7:42am UTC](https://community.glideapps.com/t/bar-chart-not-displaying-on-iphone-device/66130/2 "2023-09-14T07:42:31Z")
Here is a screenshot from my iPhone. ![IMG_7286](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/0/9/09c610491ff49371126b6024a5fefa7e9ef7aeb2.jpeg) ---
**Author:** ![ThinhDinh](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/thinhdinh/32/49_2.png) [@ThinhDinh](https://community.glideapps.com/u/ThinhDinh)\ **Post date:** [September 14, 2023, 8:04am UTC](https://community.glideapps.com/t/bar-chart-not-displaying-on-iphone-device/66130/3 "2023-09-14T08:04:50Z")
What column are you using to get the months? Is it “date format”? ---
**Author:** ![Simon\_Hill](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/simon_hill/32/94730_2.png) [@Simon\_Hill](https://community.glideapps.com/u/Simon_Hill)\ **Post date:** [September 14, 2023, 8:12am UTC](https://community.glideapps.com/t/bar-chart-not-displaying-on-iphone-device/66130/4 "2023-09-14T08:12:29Z")
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! ---
**Author:** ![Simon\_Hill](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/simon_hill/32/94730_2.png) [@Simon\_Hill](https://community.glideapps.com/u/Simon_Hill)\ **Post date:** [September 14, 2023, 8:16am UTC](https://community.glideapps.com/t/bar-chart-not-displaying-on-iphone-device/66130/5 "2023-09-14T08:16:30Z")
![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/3/f/3fa0c3f4d643d3a2097048770d7485861572cfcc.jpeg) ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/e/3/e3314320773c121c74e7098396a889c554cd5bf6.jpeg) ---
**Author:** ![Simon\_Hill](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/simon_hill/32/94730_2.png) [@Simon\_Hill](https://community.glideapps.com/u/Simon_Hill)\ **Post date:** [September 14, 2023, 8:25am UTC](https://community.glideapps.com/t/bar-chart-not-displaying-on-iphone-device/66130/6 "2023-09-14T08:25:15Z")
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. ---
**Author:** ![Darren\_Murphy](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/darren_murphy/32/47326_2.png) [@Darren\_Murphy](https://community.glideapps.com/u/Darren_Murphy)\ **Post date:** [September 14, 2023, 8:55am UTC](https://community.glideapps.com/t/bar-chart-not-displaying-on-iphone-device/66130/7 "2023-09-14T08:55:40Z")
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? ---
**Author:** ![Simon\_Hill](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/simon_hill/32/94730_2.png) [@Simon\_Hill](https://community.glideapps.com/u/Simon_Hill)\ **Post date:** [September 14, 2023, 8:57am UTC](https://community.glideapps.com/t/bar-chart-not-displaying-on-iphone-device/66130/8 "2023-09-14T08:57:27Z")
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: ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/5/f/5f64256f1cde65357b967154f59d6ec1d8e35135.png) ---
**Author:** ![Darren\_Murphy](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/darren_murphy/32/47326_2.png) [@Darren\_Murphy](https://community.glideapps.com/u/Darren_Murphy)\ **Post date:** [September 14, 2023, 9:02am UTC](https://community.glideapps.com/t/bar-chart-not-displaying-on-iphone-device/66130/9 "2023-09-14T09:02:31Z")
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) ---
**Author:** ![Simon\_Hill](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/simon_hill/32/94730_2.png) [@Simon\_Hill](https://community.glideapps.com/u/Simon_Hill)\ **Post date:** [September 14, 2023, 9:10am UTC](https://community.glideapps.com/t/bar-chart-not-displaying-on-iphone-device/66130/10 "2023-09-14T09:10:21Z")
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… ---
**Author:** ![Darren\_Murphy](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/darren_murphy/32/47326_2.png) [@Darren\_Murphy](https://community.glideapps.com/u/Darren_Murphy)\ **Post date:** [September 14, 2023, 9:28am UTC](https://community.glideapps.com/t/bar-chart-not-displaying-on-iphone-device/66130/11 "2023-09-14T09:28:32Z")
> [@Simon\_Hill](#): > > 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] 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: `Year(Date)` - Use another Math column to extract the Month number: `Month(Date)` - 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. ---
**Author:** ![ThinhDinh](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/thinhdinh/32/49_2.png) [@ThinhDinh](https://community.glideapps.com/u/ThinhDinh)\ **Post date:** [September 14, 2023, 11:21am UTC](https://community.glideapps.com/t/bar-chart-not-displaying-on-iphone-device/66130/12 "2023-09-14T11:21:01Z")
We have seen enough reports to see “Format Date” isn’t reliable at all for iOS. ---
**Author:** ![Simon\_Hill](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/simon_hill/32/94730_2.png) [@Simon\_Hill](https://community.glideapps.com/u/Simon_Hill)\ **Post date:** [September 16, 2023, 7:40pm UTC](https://community.glideapps.com/t/bar-chart-not-displaying-on-iphone-device/66130/13 "2023-09-16T19:40:58Z")
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. ---
**Author:** ![Simon\_Hill](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/simon_hill/32/94730_2.png) [@Simon\_Hill](https://community.glideapps.com/u/Simon_Hill)\ **Post date:** [September 16, 2023, 7:45pm UTC](https://community.glideapps.com/t/bar-chart-not-displaying-on-iphone-device/66130/14 "2023-09-16T19:45:48Z")
![IMG_7301](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/5/5/55da18ae1d7ad7da55d270eb4ba625c567452930.jpeg) ---
**Author:** ![ThinhDinh](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/thinhdinh/32/49_2.png) [@ThinhDinh](https://community.glideapps.com/u/ThinhDinh)\ **Post date:** [September 16, 2023, 11:11pm UTC](https://community.glideapps.com/t/bar-chart-not-displaying-on-iphone-device/66130/15 "2023-09-16T23:11:24Z")
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? ---
**Author:** ![Darren\_Murphy](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/darren_murphy/32/47326_2.png) [@Darren\_Murphy](https://community.glideapps.com/u/Darren_Murphy)\ **Post date:** [September 17, 2023, 2:14am UTC](https://community.glideapps.com/t/bar-chart-not-displaying-on-iphone-device/66130/16 "2023-09-17T02:14:09Z")
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? ---
**Author:** ![Darren\_Murphy](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/darren_murphy/32/47326_2.png) [@Darren\_Murphy](https://community.glideapps.com/u/Darren_Murphy)\ **Post date:** [September 17, 2023, 4:51am UTC](https://community.glideapps.com/t/bar-chart-not-displaying-on-iphone-device/66130/17 "2023-09-17T04:51:20Z")
@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. > **[Sales Chart Demo - Darren](https://sales-chart-demo-dar-nj5g.glide.page/)** 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: > **[Sales Chart Demo - Darren](https://go.glideapps.com/template/U0yi3hqghDm6wzu4Zs8x-template-published?privateTemplateToken=Dw0vlgxTMY8XjLWgnzOe)** ---
**Author:** ![Simon\_Hill](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/simon_hill/32/94730_2.png) [@Simon\_Hill](https://community.glideapps.com/u/Simon_Hill)\ **Post date:** [September 17, 2023, 6:26am UTC](https://community.glideapps.com/t/bar-chart-not-displaying-on-iphone-device/66130/18 "2023-09-17T06:26:11Z")
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. ---
**Author:** ![Simon\_Hill](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/simon_hill/32/94730_2.png) [@Simon\_Hill](https://community.glideapps.com/u/Simon_Hill)\ **Post date:** [September 17, 2023, 10:07am UTC](https://community.glideapps.com/t/bar-chart-not-displaying-on-iphone-device/66130/19 "2023-09-17T10:07:40Z")
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… ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/5/0/50e1ab817729f639f0c709fb3c6aacf6a64d12c8.jpeg) Any tips on why that simple time maths formula is not working please? ---
**Author:** ![Darren\_Murphy](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/darren_murphy/32/47326_2.png) [@Darren\_Murphy](https://community.glideapps.com/u/Darren_Murphy)\ **Post date:** [September 17, 2023, 10:49am UTC](https://community.glideapps.com/t/bar-chart-not-displaying-on-iphone-device/66130/20 "2023-09-17T10:49:55Z")
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: ```auto Trunc(Now-Date) ``` [Next page](https://community.glideapps.com/t/bar-chart-not-displaying-on-iphone-device/66130.md?page=2)