Analyses Column Showing Null When Dataset Shows values

Question & Answer
, , ,
1

I used a Postgresql query to build a dataset. The dataset results show values/results in a column and works as designed. When I build the analyses this same column does not show values/results, every cell in the column is null. The data for this column is coming from a left join in the query. This query works successfully in query manager(Datagrip) and tests and QA’s successfully. Once it is used in analyses, I do not get any values. One article says to change the data type in the dataset but that does not work. Any ideas? What additional information may I provide?

2

Hi @JS315

Kindly share the details of your analysis including the visual and filters applied if any. Include the dataset definition (Join details, field definitions etc) as well.

Regards,
Giri

3

Hi @JS315 ,

Please follow these simple steps

  1. Add the column to the pivot table and apply the filter to that visual.
  2. Exclude the null values from the visual. If you see data, then it is fine. If there is no data, you can recheck the query.

Note: When you include data with null values in any visual, the null values will always appear first. This doesn’t mean there are no other values in that column. It is better to exclude the null values or sort the values from Z to A."

Thanks & Regards
Biswajit Dash

1 Like
4

Hi,
Thank you for your responses. I appreciate it. The data set query works as designed and returns values for names in a “user” column. The same query works successfully in query manager and returns values for users in a “user” column. It only fails in the QS analysis.

Dataset with data:

image
image1629×859 50.5 KB

I have attempted to change datasets and remove nulls.

1 Like
5

Resolved. The analysis doesn’t show the data but the export does. Will see why.

2 Likes