Charts reading User selectors gives an error for null values

[nahiyan-yasaar-selise]

Is there an existing issue for this?

• I have searched the existing issues

Version of Corteza

2024.9.0

Current Behavior

When I build a chart that takes a User Selector as the metric's field, I get an error if there are any missing values. Inputting a default value doesn't work. I need to tick 'skip missing values' to get rid of the error so that the chart can render at all, but I would also like to know how many have missing values.

Expected Behavior

The chart should still render with missing values as its own section (pie chart) or bar (bar chart), similar to taking Record Selectors.

Steps To Reproduce

1. Create a module with a User Selector field
2. Create multiple records
3. Provide a user for a subset of the records, leaving the others blank
4. Create a chart with the user selector field as a metric

Environment and versions

Also occurs in 2023.9.7

Anything else?

No response

[Fajfa]

Can confirm
You can use the Default Value Option as a workaround for now. You'll have to use a numeric value though 0 for example.

[Fajfa]

After further investigation, it's a Postgres issue.
Will be fixed in the future.