if i have a date table and then create another table and use date as a reference in that new table. It works but when i create a chart off that new table using date along the axis it shows weird data:
as opposed to using date as a standalone field in the second table:
I know that date number in the lower right hand corner of the top image : 1714089600… is a linux formatted date. So seems like the chart is not happy with a reference field. any work arounds?
Try adding the date field from the referenced table into the new table, as explained in Including multiple fields from a reference.