In-DB tools - how to only select records where particular column is not null YTD

Question

Hopefully someone can help me figure this out. Apologies if I'm posting this in the wrong forum.

I can't get too detailed because I'm developing a table with very sensitive data, but I need to find a way to select only the records where a certain string field is non-null over the whole year/YTD and an indicator variable is = 1 over the whole year/YTD. I need to use the in-db tools as I'm pulling large amounts of data all at once. Any help or ideas is much appreciated!

JacobLuke · Answer

@phottovy Thanks a ton! I'll try this sometime this week and get back to you! Appreciate the help guys!

phottovy · Answer

Hi @JacobLuke ,

Edited to include month calculations:

If I'm understanding your question correctly, you should be able to accomplish this using a handful of tools .

* First use the filter tool to include only the year you want to calculate. 
* Use a formula tool to calculate the month 
* You can then use a summarize tool to get the total Count, Count Null, and Count Non Null for your string field

* Calculate the null percentage with another formula tool

Sample workflow:

JacobLuke · Answer

Yes! I need both null and non-null. I'll try getting a mockup posted as soon as I'm able. Thank you for the reply! @patrick_mcauliffe