Why do my values when pulling review statuses for notebook entries on Insights show up as null?

Sewon
Sewon
  • Updated

Issue

When I pull the values for the review statuses of notebook entries on Insights, some of them show up as Null, alongside with "RETRACTED", "REJECTED", "NEEDS_REVIEW", and "ACCEPTED".

 

Environment

Insights, Notebook

 

Cause

The null values represent the "In Progress" statuses since they are technically not in a review status.

 

Resolution steps

If you would like these null values to represent "In Progress", you can use a coalesce statement (https://colab.research.google.com/drive/1VNBX7dwHiq35iGW7ZrubDkBKZyifKUkA) to get the nulls to say that.

Was this article helpful?

Have more questions? Submit a request