I notices, when I am using more LOD (more calculated fields with Include), it will filter me only that rows which has the last calculation > 0
Adding empty rows by Analysis -> Table layout etc.... will show me others with empty values, but I know that other has some value.
Is is a nightmare, when I use COUNTD I have the correct solution, but because of Impala I cannot do multiple COUNTD in one table
That is a interesting behavior that is occurring with the LOD calculations in use. Is there anyway that screenshots could be provided in demonstrating this behavior.
I also found the thread below that touches on the use of multple CountD usage in Impala.
Hope this helps!