MinMax Scaling chart function

[rrodr244]

Hi Folks,

I'm creating a slider to enable users to select less or more relevant count of words in a word cloud. In order to have a simple understanding about the scale, I want to apply the MinMax Scaling formula in the charts:

Below I have a table with the work frequency, but I'm not getting the proper chart code to add new columns with Min(Count(feature) and Max(Count(feature) in order to have the above formula applied to a row level and considering user selection. For instance, If I select 3 words, Min and Max values should be updated to the value range available. I tried some AGGR coding, but didn't get proper results.

Do you have some tip to help me?

Tks

Rubens

[GaryGiles]

Try this to calculate your scale calculation at a feature row level:

(count(feature)-min(Total aggr(count(feature),feature)))
/(max(Total aggr(count(feature),feature))-min(Total aggr(count(feature),feature)))