OData in Google Data Studio not giving STATE AND ACTIONS field - ODK Central

[Saad]

Hi,

I have my central form hooked up with Google Data Studio, but unable to see the STATE AND ACTIONS field in the GDS table. How to include these? I think I heard Yaw saying this in a recent webinar that this field does get streamed in the OData feed (Am I right?).

Thanks,
Saad

[danbjoseph]

Please see this thread:

ReviewState does not appear during Central OData transfer to Power BI

Review state is in the __system column. You can confirm, by following these steps. From Home, click on the Transform data in the menu bar to open up Power Query. On the right-hand side of the screen, you should see the list of Applied Steps. Click on Navigation. Now at the top of the screen, you should see your __system column. Expand it. You should now see reviewState. [Screen Shot 2021-06-30 at 09.18.19] As to how you adjust your Power BI dashboard to include that new column, that's depen…

[Saad]

Hi,

So I am using the tutorial on https://getodk.org/google-data-studio/ for integrating GDS with ODK Central via the mentioned plugin. After entering the project URL, Google Data Studio pulls the form fields itself (no options given to me), which contain all form fields and only 2 system fields (__system/submissionDate, and __system/submitterName). Rest all remaining fields are the ones coded in the form.

I do get the field in the CSV downloaded from central dashboard though, as well as I can see it in EXCEL via OData connection, as mentioned by Yaw above. However, it is not really showing in the OData stream in Google Data Studio, and I don't see any option around to tweak it.

Regards,
Saad