# Bar chart dont show on iphone but in preview
**URL:** https://community.glideapps.com/t/bar-chart-dont-show-on-iphone-but-in-preview/69179
**Category:** Ask for Help
**Created:** [January 2, 2024, 4:02pm UTC](https://community.glideapps.com/t/bar-chart-dont-show-on-iphone-but-in-preview/69179 "2024-01-02T16:02:29Z")
**Posts on this page:** 17
**Page:** 1
### Author:  [@IlseB](https://community.glideapps.com/u/IlseB)
#### Post date: [January 2, 2024, 4:02pm UTC](https://community.glideapps.com/t/bar-chart-dont-show-on-iphone-but-in-preview/69179/1 "2024-01-02T16:02:29Z")
Hi,
I have built a bar chart but this is not showing up when i log into my user account on my iphone. i have checked the following:
- its not restricted via filter or visiblity
- its not restricted via row owners
- the data shows accurately where i preview my app on my laptop
- interesting to observe, the big numbers, total enquiries and the bar chart is build using the same datasource from the same table - on my mobile device, big numbers show but not the bar chart
any idea why this could be?
---
### Author:  [@Jeff\_Hager](https://community.glideapps.com/u/Jeff_Hager)
#### Post date: [January 2, 2024, 4:38pm UTC](https://community.glideapps.com/t/bar-chart-dont-show-on-iphone-but-in-preview/69179/2 "2024-01-02T16:38:48Z")
Are you doing anything weird with dates? Using any date plugins or formatting it dates in any non-conventional way?
---
### Author:  [@IlseB](https://community.glideapps.com/u/IlseB)
#### Post date: [January 2, 2024, 4:43pm UTC](https://community.glideapps.com/t/bar-chart-dont-show-on-iphone-but-in-preview/69179/3 "2024-01-02T16:43:48Z")
The only thing im doing with dates are:
1. i have rows for each month
2. i extract month number and year number
3. then i stitch them and use the template column to build a relation back to the actual table
4. i then do a count and show this on my chart.
5. i do have a date formatted column in this table but this is not used in any of the relations/templates or calcs
6. however, i am using a template column as the x-axis in all the bar charts that doesnt work…mmm
hope that makes sense?
---
### Author:  [@Jeff\_Hager](https://community.glideapps.com/u/Jeff_Hager)
#### Post date: [January 2, 2024, 4:58pm UTC](https://community.glideapps.com/t/bar-chart-dont-show-on-iphone-but-in-preview/69179/4 "2024-01-02T16:58:11Z")
> [@IlseB](#):
>
> i extract month number and year number
How are you doing this? The reason I ask is because there are some known incompatibilities with date related plugins not playing well with iPhones.
A better way to extract year and month is with a math column. It’s stable and always returned expected results. Also saves having to switch them back together.
`Year(Date)*10^2 +Month(Date)`
---
### Author:  [@IlseB](https://community.glideapps.com/u/IlseB)
#### Post date: [January 2, 2024, 5:01pm UTC](https://community.glideapps.com/t/bar-chart-dont-show-on-iphone-but-in-preview/69179/5 "2024-01-02T17:01:16Z")
> [@Jeff\_Hager](#):
>
> Year(Date)\*10^2 +Month(Date)
i have the following - see screenshots
---
### Author:  [@Jeff\_Hager](https://community.glideapps.com/u/Jeff_Hager)
#### Post date: [January 2, 2024, 5:08pm UTC](https://community.glideapps.com/t/bar-chart-dont-show-on-iphone-but-in-preview/69179/6 "2024-01-02T17:08:09Z")
These look suspicious to me. You are grabbing year AND month from a text based Month column??? Two thoughts are that you are either pointing the year to the wrong column, or there is a problem with the Month column being a text column instead of a date column.
---
### Author:  [@IlseB](https://community.glideapps.com/u/IlseB)
#### Post date: [January 2, 2024, 7:46pm UTC](https://community.glideapps.com/t/bar-chart-dont-show-on-iphone-but-in-preview/69179/7 "2024-01-02T19:46:39Z")
> [@Jeff\_Hager](#):
>
> Year(Date)\*10^2 +Month(Date)
Hi Jeff,
I have now done the following, with no luck:
- Changed the Month column to be a date format
- created a new extract math column with your formula successfully
- also used the same formula in the lookup table
- updated my relation column to match my two template columns
- the figures on the table shows correctly, also when i open the app on my macbook, the bar chart shows… but still on iphone it doesnt show
see screenshots
---
### Author:  [@Jeff\_Hager](https://community.glideapps.com/u/Jeff_Hager)
#### Post date: [January 2, 2024, 8:12pm UTC](https://community.glideapps.com/t/bar-chart-dont-show-on-iphone-but-in-preview/69179/8 "2024-01-02T20:12:47Z")
Nothing is immediately jumping out to me. Have you tried in a different device, such as an Android device?
Okay, just to verify, in your earlier screenshots, your template has month before year, and now month is after year. I just want to make sure that it’s consistent on both ends of the relation. I assume you still have the same results where the builder shows the chart, but the phone does not?
Can you also share a screenshot from the other table including the ExtractMonthYear\_Status column?
Also a screenshot of the chart configuration?
Also, for debugging purposes, can you add a text component to the screen with the chart that maybe shows the template column value, just to verify that dates are formatting correctly. I’m sure it’s just a configuration issue somewhere along the line, but I’d need more info to determine that.
---
### Author:  [@IlseB](https://community.glideapps.com/u/IlseB)
#### Post date: [January 2, 2024, 8:19pm UTC](https://community.glideapps.com/t/bar-chart-dont-show-on-iphone-but-in-preview/69179/9 "2024-01-02T20:19:17Z")
> [@Jeff\_Hager](#):
>
> Okay, just to verify, in your earlier screenshots, your template has month before year, and now month is after year. I just want to make sure that it’s consistent on both ends of the relation. I assume you still have the same results where the builder shows the chart, but the phone does not?
Correct, the results on the chart builder is correct, but the phone doesnt show the chart. further to this i have realised that if i remove my filter (to filter for the specific month only), the chart actually shows on the iphone. This is the filter i currently have: new yearmonth field equals current yearmonth field based on your formulas.
---
### Author:  [@IlseB](https://community.glideapps.com/u/IlseB)
#### Post date: [January 2, 2024, 8:20pm UTC](https://community.glideapps.com/t/bar-chart-dont-show-on-iphone-but-in-preview/69179/10 "2024-01-02T20:20:21Z")
> [@Jeff\_Hager](#):
>
> Can you also share a screenshot from the other table including the ExtractMonthYear\_Status column?
---
### Author:  [@IlseB](https://community.glideapps.com/u/IlseB)
#### Post date: [January 2, 2024, 8:26pm UTC](https://community.glideapps.com/t/bar-chart-dont-show-on-iphone-but-in-preview/69179/11 "2024-01-02T20:26:14Z")
> [@Jeff\_Hager](#):
>
> Also a screenshot of the chart configuration?
Table:
This is the filter that stops the chart from showing on iphone…
Without the filter it shows on iphone, but it shows a sum of all values …that is not correct as i need to filter the shart for this month only:
Here is the other tables field that is part of the relation:
---
### Author:  [@IlseB](https://community.glideapps.com/u/IlseB)
#### Post date: [January 2, 2024, 8:29pm UTC](https://community.glideapps.com/t/bar-chart-dont-show-on-iphone-but-in-preview/69179/12 "2024-01-02T20:29:22Z")
> [@Jeff\_Hager](#):
>
> Also, for debugging purposes, can you add a text component to the screen with the chart that maybe shows the template column value, just to verify that dates are formatting correctly. I’m sure it’s just a configuration issue somewhere along the line, but I’d need more info to determine that.
---
### Author:  [@IlseB](https://community.glideapps.com/u/IlseB)
#### Post date: [January 2, 2024, 8:42pm UTC](https://community.glideapps.com/t/bar-chart-dont-show-on-iphone-but-in-preview/69179/13 "2024-01-02T20:42:33Z")
---
### Author:  [@Jeff\_Hager](https://community.glideapps.com/u/Jeff_Hager)
#### Post date: [January 2, 2024, 9:14pm UTC](https://community.glideapps.com/t/bar-chart-dont-show-on-iphone-but-in-preview/69179/14 "2024-01-02T21:14:16Z")
I’m really just throwing out random ideas, so bare with me. Everything looks to be set up correctly. Obviously 202401 should match 202401…but I also noticed that you have ‘Respect Timezones’ enabled on your Month date column. Assuming that all dates have a time of midnight, I’m wondering if it’s converting to a different timezone, and thus a different day on the iPhone, so you end up with mismatched new and newcurrent values. For this specific use case, there should be no reason to have ‘Respect Timezones’ enabled since I assume it’s a static date that should be the same for everyone. I would think if this is the case, you would see it reflected on your phone in the Fields component.
---
### Author:  [@ThinhDinh](https://community.glideapps.com/u/ThinhDinh)
#### Post date: [January 2, 2024, 11:55pm UTC](https://community.glideapps.com/t/bar-chart-dont-show-on-iphone-but-in-preview/69179/15 "2024-01-02T23:55:41Z")
Please try opening the builder in Safari on your Mac, test all the related columns to see if they all return correct values. Nothing is immediately jumping out to me, but maybe adding more relevant columns to the fields component and test them between your Mac and your iPhone to see if there’s a difference.
---
### Author:  [@IlseB](https://community.glideapps.com/u/IlseB)
#### Post date: [January 3, 2024, 5:17am UTC](https://community.glideapps.com/t/bar-chart-dont-show-on-iphone-but-in-preview/69179/16 "2024-01-03T05:17:00Z")
Thanks alot both of you, @ThinhDinh and @Jeff_Hager , after taking a break I realised even though I added the Date column also to the Fields component, it didnt show due to the format. on the surface it looked like an acceptable format, but after retyping all the months in the table the charts appeared 🙂
---
### Author:  [@system](https://community.glideapps.com/u/system)
#### Post date: [January 10, 2024, 5:17am UTC](https://community.glideapps.com/t/bar-chart-dont-show-on-iphone-but-in-preview/69179/17 "2024-01-10T05:17:24Z")
This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.