I have multiple gauge charts with different expressions. Lets take this expression for example:
Productief: AVG(VERLOFAFGEBOEKT) / 8
Sometimes when some values are selected a gauge charts shows the message 'No data to display'. To get rid of that message and instead let it show null i add this expression:
alt (Productief, 0)
This solution works however there is one problem. When i mouse over the pointer of the gauge chart it doesnt't show the right value. If for example the result is '171' the pop up label shows '17171,298...'.