Forum Discussion

avitoriasrocha's avatar
avitoriasrocha
Regular Visitor
3 years ago
Solved

How to show zero values in a matrix

Hello guys! I need a lot of help with the following: In an matrix, I put the priority as a criterion and the rankings as follows in the image: In this case, there is also a priority "Critica...
Need Help
Tutorial Requests
  • PabloDeheza's avatar
    PabloDeheza
    3 years ago

    Hi avitoriasrocha !
    Try an if condition like:

    IF(
	value = BLANK(),
	0,
	value
)

    Let me know if that helps!

KNP's avatar
KNP
Super User
3 years ago

I'm answering from my phone so I'll do my best to explain without screenshots.

One way to do it...

  • Select the visual that you want priority to show all for.
  • In the field well (I think that's what it's called) in the visualisation pane on the right, where you drop your fields in for the visual, right click on priority and select 'Show items with no data'

Let me know if that helps.