Profile Picture

hide chart if error

Posted By Philip Saxegaard 7 Years Ago
Author
Message
Philip Saxegaard
Posted 7 Years Ago
View Quick Profile
Forum Newbie

Forum Newbie (1 reputation)Forum Newbie (1 reputation)Forum Newbie (1 reputation)Forum Newbie (1 reputation)Forum Newbie (1 reputation)Forum Newbie (1 reputation)Forum Newbie (1 reputation)Forum Newbie (1 reputation)Forum Newbie (1 reputation)

Group: Forum Members
Last Active: 7 Years Ago
Posts: 0, Visits: 2
Hi
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.

Greetings
Philip

Nevron Support
Posted 7 Years Ago
View Quick Profile
Supreme Being

Supreme Being (4,186 reputation)Supreme Being (4,186 reputation)Supreme Being (4,186 reputation)Supreme Being (4,186 reputation)Supreme Being (4,186 reputation)Supreme Being (4,186 reputation)Supreme Being (4,186 reputation)Supreme Being (4,186 reputation)Supreme Being (4,186 reputation)

Group: Forum Members
Last Active: 12 hours ago
Posts: 2,994, Visits: 3,512
Hi,

Currently you cannot handle the case when an expression in the pivot throws an error. You can however try to first remove the error by writing an expression that handles it, and then hide the chart area based on the input values. The same goes for an error title - you can make it conditionally visible, if the data that needs to be displayed is not expected. 


Best Regards,
Nevron Support Team





Similar Topics


Reading This Topic