I have a chart that will show this message: An error occured during the web part rendering. The error was: Object cannot be cast from DBNull to other types.
I recieve this error message bacause there are no data in my list, and that is by design. Is it possible to make an IF statement in the value field in the pivot that chacks if the calculation returns an error or not?
I want to display a title that says exactly what went wrong for my users. The reason I want to avoid the default error message, is because the chart stops automatically refreshing in the interval.