Finding out which division is missing

user091100
user091100 βšͺ️

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.