Last answered:

08 Nov 2021

Posted on:

24 May 2021

0

The four nulls of Chart 3

How did you take care of the 4 null values of chart 3 before starting the dashboard build? because i feel like they're causing me not to be able to select chart 3 when i attempt to use the "audiobook name" filter on chart 3. it works on chart 1 & 2

Screen Shot 2021-05-24 at 5.38.49 PM.png

Screen Shot 2021-05-24 at 5.39.01 PM (3).png

3 answers ( 0 marked as helpful)
Instructor
Posted on:

28 Jul 2021

0

Hi Lionel,
I believe you could right-click on the chart and opt to exclude null values.
Please try to do that and let me know if you need additional help. Thanks!
Best,
Ned

Posted on:

02 Sept 2021

0

I had this same issue and I removed the nulls but I still was not able to add the filter to me third chart for the dashboard. If this happens, you can add the filter manually to your chart in the same fashion as you did with the pie chart.

Posted on:

08 Nov 2021

1

EDIT: video entitled "Interactive filters - fix" has already been added to the course to solve this issue.

Exclude the null data first.

The third chart cannot be filtered probably because "Audiobook name" was (accidentally or unintentionally) removed from the blend relationships by following the instructor steps on previous video. To solve this, simply adds "Audiobook name" to the custom blend relationships. The reviews/sales chart now should be able to be filtered based on "Audiobook name". Hope it helps.

image.png

image.png

Submit an answer