Bar chart dont show on iphone but in preview

[IlseB]

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?

[Jeff_Hager]

Are you doing anything weird with dates? Using any date plugins or formatting it dates in any non-conventional way?

[IlseB]

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?

[Jeff_Hager]

@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)

[IlseB]

@Jeff_Hager

Year(Date)*10^2 +Month(Date)

i have the following - see screenshots

[Jeff_Hager]

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.

[IlseB]

@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

[Jeff_Hager]

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.

[IlseB]

@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.

[IlseB]

@Jeff_Hager

Can you also share a screenshot from the other table including the ExtractMonthYear_Status column?

[IlseB]

@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:

[IlseB]

@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.

[IlseB]

[Jeff_Hager]

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.

[ThinhDinh]

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.

[IlseB]

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