Hi,
Summary:
Looking to reset a specific table cell to Null as it's currently showing as Blank (due to deleting previous data within that cell)
Context:
Working with a ArcGIS Online Hosted Feature Layer, which is being updated by Surveys.
I've made a dashboard to display the results, however when I ran a test on two of the surveys that update fields I filled out a response which skewed the pie charts based on Responses.
Initially the data was showing as below (example):
CompanyID | RespondentA | ResponseA | RespondentB | ResponseB |
ABC123 | TestUser | Accept | TestUser | Accept |
ABC234 | TestUser | Reject | TestUser | Reject |
ABC345 | User1 | Accept | User2 | Accept |
ABC456 | User1 | Reject | User2 | Reject |
ABC567 | <null> | <null> | <null> | <null> |
ABC678 | <null> | <null> | <null> | <null> |
Where ABC123 and ABC234 were the test data. With the pie chart showing 2 Accept, 2 Reject and 2 Null values per Response (A or B)
However, having deleted the data from the fields for ABC123 and ABC234 the table now looks like:
CompanyID | RespondentA | ResponseA | RespondentB | ResponseB |
ABC123 | | | | |
ABC234 | | | | |
ABC345 | User1 | Accept | User2 | Accept |
ABC456 | User1 | Reject | User2 | Reject |
ABC567 | <null> | <null> | <null> | <null> |
ABC678 | <null> | <null> | <null> | <null> |
This now displays as 2 Blank, 1 Accept, 1 Reject and 2 Null on the pie chart.
Is there a way to reset the specific Respondent A/B or Response A/B cells to <null> by CompanyID, specifically for ABC123 or ABC234 without resetting all cells in the Respondent A/B or Response A/B columns?
e.g. Where CompanyID is ABC123 set ResponseA is None (<null>)
Thanks in advance.
