Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi Everybody
I have a table like this:
ID | ID Padre |
---|---|
IM23456 | |
IM26788 | |
IM74777 | IM78789 |
IM34677 | |
IM98789 | |
IM44323 | IM98767 |
The idea is to count and show in a graphic only the elements in ID field that don´t have any data in ID Padre field, for the example would be 4 ID because i have 2 Items with data in ID Padre field.
How can i make this?
Maybe this?
count(if(len("ID Padre")=0,ID))
!Thanks for your great help¡