Keep track status of a monthly fix work

[msyamil]

Hi everyone, 

So basically every month, our team have a fix task to do. For example: doing stock count and report it in the spreadsheet. I am trying to automate the process, by having everyone to submit their data via the Google Form, which later updated to Spreadsheet.

I am wondering if there is a way for the Looker Studio to show who haven't submit the data yet? I know Looker mainly to show what data it has, but is there any way to show when a data is absent?

Thank you.

[sam8]

This may be possible, but it depends a lot on your setup.

For example, I could image a case where every submission has a Name and Month attached. Then you could make a pivot table where both Name and Month are dimensions, and maybe Submission Count is your metric. Then, the table would show 0 for any Name/Month combos for which there is no data, which would basically give you a way to see which users haven't submitted for a given month. 

[lauratilton]

In this example, if the Name/Month combos were based on submissions, then there wouldn't be any Name/Month combos if the person hadn't submitted any data, so there would be no row for 0 in the pivot table. I think you'd need to set up a blend to incorporate a master name list to create a row in the table even when no submissions had been made.

[lauratilton]

Another suggestion for your use case: Have you considered utilizing links in your Looker Studio report to prefilled forms? That way you could start with a data source that shows all the required Month/Person/Task combinations, and then set up the prefilled form link to bring in Month/Person/Task (you'll have to create the field CONCAT once you have the URL syntax) and incorporate it in your report. The person clicks the link, which will have Month/Person/Task prefilled, and they fill out any other necessary fields. Then blend on Month/Person/Task to get the master table of all the tasks which will show which ones have been completed.

Of course, this assumes your Form users also access the report, which may not be true.

If you want to see an example of how this works, let me know.