Forum Discussion
TREATAS missing values
Hello thank you for helping me. I have tried your method however there were still missing values. My guess is due to me using TREATAS(?). In order to correctly show score2 based on a name that was selected from bd1, score2 will treat the name selected in db1 as the name selected in db2. Thus if for the particular week score1 does not a value score2 would not be displayed because it was filter based on bd1?
Maybe by forcing the line chart to show all the weeks would solve this how ever my weeks are not in date format thus I cant change their type to categorical.
Tried to click the "show items with no data" but it did not do much.
Are you sure that values are missing? Looking at the table you initially posted, in week 10 there is a value of 100% but there is no value for 5, which is exactly what the chart is showing at week 10.
My apologies, this chart does not show the error for w10
Here is the chart that correspondes to the error, the data of the table on the right is based off this chart.