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.

    **Check out my Domo Tips & Tricks Videos

    **Make sure to <3 any users posts that helped you.
    **Please mark as accepted the ones who solved your issue.