Forum Discussion
Date values incorrectly flagged as blank
Community SupportHi Vicky2020 ,
I think this is cause by the relationship between two table, they are not match one by one, you could view it like below(there is no "s" in table (2), and you use value from table in chart, it will show blank). So you could try to change relationship to many to many, which should work.
Best Regards,
Zoe Zhi
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi Zoe,
Thanks so much for taking the time to look at this!
I changed the relationship to many to many and unfortunately this didn't solve the issue. The effect it had was that instead of flagging date values as blank, it just excluded the values completely from the data set. It's so strange because I've created similar line charts without any issues, so I'm wondering if this is more of a glitch with the system than an actual problem with the data model setup.
I'm going to try and create a new column that captures the date value and not the time value in the support request table and see if that solves the issue.
If you have any other suggestions, I would be happy to try it!
Many thanks again for your help!