Interactive Chart Tool - numbers not in numeric order

Hi,

I have an example data set in the following form. The null values are greyed out in Alteryx. I want to create a chart with the date on the X Axis and the values of different attributes on the Y-Axis. However, the Y-AXIS is screwed in that it is not in numeric order, e.g. shows null, 7, 2, 9. I have tried the cleanse tool before using the interactive chart tool to change [null] to zero, however for some reason after the successful run of the cleanse with no error messages, I see no output data. Can anyone please help?

Date	Attribute 1	Attribute 2	Attribute 3	Attribute 4
2020-05-01	[null]	[null]	[null]	3
2020-05-02	2	[null]	[null]	6
2020-05-03	[null]	7	[null]	9

Many thanks,

Sylvia

Reporting

Help

Accepted answers

If those fields are numeric it should work without a problem.

Alternatively you can use a formula like this to change null positions to zeros.

IIF(IsNull([Attribute 1]), 0, [Attribute 1])

All comments

Please pick respective columns and make sure that you are choosing the option below:

Please let me know if this started to work.

No unfortunately not. That's what I've tried already.

This is input data for illustrative purposes

and then I run the cleanse tool selecting all columns to cleanse and "replace with 0 (numeric fields). I then get this

Quick Links

Tags

This months top contributors

atcodedog05 19598

Qiu 15867

MarqueeCrew 13708

apathetichell 13703