Finding out which division is missing

user091100
user091100 βšͺ️
in Card Building

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.



    **Make sure to like any users posts that helped you and accept the ones who solved your issue.**

Categories