Hi Team,
Would you please advise how to show Null counts in Line Chart, in case Null data included in Color field? The attached line chart on the right-bottom, with the sales sub channel of color field, cannot capture Null data & it’s category. A field in Color (e.g. sales_sub_channel here) is not supporting Null data ?
In short, 720 includes appx.600 of Null (in terms of sales_sub_channel) in top tables, but no line presented in right-bottom line chart.
Best regards,
Hello @Junny !
Can you go to the field that’s in your value field well and go to “More Formatting Options” in the drop down.
Can you try entering a value in the custom null value option?
Hi Duncan,
Thanks for your advice. However, it doensn’t works. If I remove the sales_sub_channel from the color window, total counts seems to capture all Null counts as shown. In this sense, I presume the color window has issue to handle this.
(Note. 720 sales has been increased over time)
Hi @Junny,
One option could be to create a calculated field that tests for NULLs and changes them to a fixed value (string) such as “null_channel”, I did the following:
Create a calculated field handledNulls_sub_sales_channel as follows
ifelse(isNull({sales_sub_channel}),'null_channel',{sales_sub_channel})
I then built a line chart visual using the displayed Field wells:
This plots the consolidated line values (green line in my example) where sales_sub_channel is NULL.
Let me know if this helps.
Many Thanks,
Andrew
