Interactive Chart Tool - numbers not in numeric order

[SylviaK]

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

[Emil_Kos]

Hi @SylviaK,

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

Please let me know if this started to work.

[SylviaK]

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

[Emil_Kos]

Hi @SylviaK,

Just one additional question. 

Do you have those options ticked?

[SylviaK]

I don't see those options in the cleanse tools. 

[Emil_Kos · Accepted solution]

Hi @SylviaK,

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])

[SylviaK]

many thanks. Using the formula works.