Automatic Scoring.

Hello everyone,

I'm beating my head with this and hoping someone can help me with this, I think it's simple but just can't think through it.

I want to use Alteryx to automatically assign a score on a scale of 0 - 10, including decimals for anything between 0 - 10.

The scoring is based on the last date a file was saved versus the current date calculated in seconds, for instance:

Last saved: 2020-09-08 15:54:47

Current date: DateTimeNow() function in Alteryx

Then the difference in seconds using the DateTimeDiff function.

All this is fine, but what I'm struggling next is to figure out the logic to assign on a scale 0 - 10, including decimals for anything between 0 - 10, for any file with lowest difference closer to 10 if not 10 exact, then it goes lower as the difference becomes greater.

Any help would be greatly appreciated.

Thanks!

Workflow

Tips and Tricks

Transformation

Help

Expression

Accepted answers

phottovy

Let me know if this is what you are looking for. I basically calculate to the oldest date, then calculate every other date difference as a percentage of the oldest date difference. After that, you just need to multiply the percentage by your scoring number, 10 in this case.

The attached workflow creates 100 random dates to go with your provided date and then scores them between 0 and 10.

Automatic Scoring.yxmd

All comments

AbhilashR

Hi @TwanD, I am thinking writing some form of formula and assigning a scale value based on the time difference range might be a potential approach, but the intervals depend on what you see in your sample set. If you had to do this manually, how would you assign the scale? Also feel free to share some sample dataset for everyone to better help.

TwanD

@AbhilashR

Please see the attached sample workflow. Currently the difference is calculated on days and the scoring is manually assigned based on a range. The result ultimately feeds into a Power BI visualization and I run into issues with each file overlaps each other in a quadrant chart (this scoring is one of the two I used for the chart).

I want to see each file as its own dot so thinking of calculating the differences on seconds instead of day but want to have the scoring automatically applied using a logic instead of manually putting in a number in the scale of 0 - 10.

Thanks.

Time Since Last Saved Score.yxmd

phottovy

The attached workflow creates 100 random dates to go with your provided date and then scores them between 0 and 10.

Automatic Scoring.yxmd

Qiu

@TwanD

By any chance, Multi Field Banning is what are looking for?

Time Since Last Saved Score.yxmd

TwanD

@phottovy This is what I'm looking for, thank you so much! I definitely could not think it through like you did. Will test it out with my own data and will reach back out if I still have issues.

Thanks!!!

Quick Links

Unanswered
Community Events
Groups

This months top contributors

atcodedog05 19598

Qiu 15867

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703