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
Solved! Go to Solution.
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.
@JingLi
This is strange to me.
The datatype is "V_WString", so the data shall be '1'. Or change the data type to Int/
i found it strange too, but i tested it here and it works fine. I was expecting a datatype error to happen.
@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.
The strange part is that i am using an older version right now (2020.3) 😅
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?
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!
Here is my configuration for the chart. I don't know why the y axis is all over the place.