Formula Help

[JingLi]

Hi there,

Can I please get an explanation of what this formula means? It is supposed to be used before an interactive chart tool, but what does the "1" represent, and why does it ha

Thank you in advance!

Jing

[Felipe_Ribeir0]

Hi @JingLi 

This formula is assigning 1 for each row of the column Key word count.

Without the workflow to see the context it is hard to know exactly why, but i would guess that this field is being used to be summed inside the chart (showing the quantity of key words) or somewhere else.

[Qiu]

@JingLi 
This is strange to me.

The datatype is "V_WString", so the data shall be '1'. Or change the data type to Int/

[Felipe_Ribeir0]

@Qiu 

i found it strange too, but i tested it here and it works fine. I was expecting a datatype error to happen.

[Qiu]

@Felipe_Ribeir0 
Thank you for sharing your test. 😁

Maybe we should cosider this as an improvement? though the old version will throw an error, which I think it is not bad either.

[Felipe_Ribeir0 · Accepted solution]

The strange part is that i am using an older version right now (2020.3) 😅

[JingLi]

Thank you for the reply. I still don't understand why do I have to assign the number 1 to each row of the column key word count.

I attached the workflow. Can you let me know your thoughts?

[Felipe_Ribeir0]

The transaction input did not came.

But it seems that this workflow is counting how many ocurrencies of key words you have in your transaction input - column comments and plotting this into a chart.

So, looking at this dummy example that i created, you have 3 key word occurrencies, right? So, if you sum the Key Word Count column, you will have 3 as result. You can think of it as a support column to count key word ocurrencies. Makes sense?

[JingLi]

@Felipe_Ribeir0 

Oh, I think I understand now. The 1 is necessary so it only count one keyword at time. 

Can you help with my chart too? 😅 I can't get the sorting to work in the chart. It won't sort the keyword count in a descending order. I attached the packaged workflow this time. 

Thank you!

[JingLi]

@Felipe_Ribeir0 

Here is my configuration for the chart. I don't know why the y axis is all over the place.