Hello, I am facing issue of data missing in one particular table column for few rows when I select long range date filter. However another column which is calculated from this column shows all data as expected.
What might be reason? Please find screenshot below where RED background column is calculated one and to the left of red background where few values are missing when long From-To date is selected.
missing some data in table column
Do you see the data in that column when you are in edit and do data preview mode?
Double check the formula, make sure it can not give a result if that number is null, this might at least tell you why the calculated column has value.
Yes, column has data. I can see in edit mode or in SQL as well.
Strange part is it shows all data in said column when I click on sort option in column header.
State that changes the text color to same as background?
I am out of guesses with out looking at it, I would call support.