I am creating a chart table (pivot table) but there is a row with a null value I dont know why.
If I dont upload any data it gives me this result:
And if I do (load data) this line keep there:
I guess the problem is in the creating of chart I not in the script. My dimensions are Day and Volume. Because of this simple problem when I make another column to just add 50 to free (the column Free+50) it gives null in every row.
Do you have any ideas? Or any guesses where the problem is?
PS. On my fields there arent no null fields (that's why I think the problem is on the setup of the chart and not in the script to load the data).
Yes, I think it was that. But do you know why the columns where I just add 50 to the last column it gives me nulls as the picture above shows? The first line is removed, but I cant calculate the sum of Free+50 on the expression of the last column it still gives nulls numbers.