Finding out which division is missing

I have a MS form that each division is supposed to fill out monthly. I pull the excel to domo. Is there a way beast mode or other to see which division hasn't completed it for the current month?

Answers

  • MarkSnodgrass
    MarkSnodgrass Portland, Oregon 🔵

    If you have a list of all divisions than you can create a Magic ETL dataflow to do a left join to your form data and then filter where the form division name is null. This would give you a list of divisions that haven't completed it.

Sign In or Register to comment.

Hey, Stranger!

It looks like you're new here. Those who sign in get access to engage with even MORE fire content. To get involved, click one of these buttons!