How to get a lift table for a binary classification predictor
Oct. 07, 2024
How to get a lift table for a binary classification predictor
@mlauber71 : Yes, I thought about that. But I am still new to KNIME, I am not sure how to do it. My two challenges are:
- How to aggregate by decile (10% chunks in the data). The workflow I generated calculates TP, FP, TN, FN at each cutoff point, not at each decile. I coded a variable based on rules for cutoff and then iterated across that variable.
-----------UPDATE: I now know how to address this point: Use the Chunk Loop Start node.---------
- I am not sure how to introduce the cumulative calculation into the loop. The table should include individual lift and also cumulative lift. If I lop across each 10% of the data, how doe I keep a cumulative count in my loop?
Thanks.
Calculating Lift % on an average base (that doesn't change ...
Ok I see what the issue is and its a difficult issue to solve. Because in the bottom graph when you click on the graph and select a day, you are filtering on the low we date and yet you want to preserve low we date filter for the visuals above for the non promo week.
To be honest I can't find a solution that isn't messy to this problem. The only way I can solve this issue is by creating another date table and relinking that and then using the date from the second calendar table on the bottom graph, and remove the filter from this new date table in the dollar % lift measure when you click on it. Not sure if that make sense.
i removed changed the bottom visual to use the calendar 2 table and that solves that problem but its not a clean solution. Also other things to consider if there is no promo value, what should the dollar lift be?
There is probably a better solution to this but without understand your business requirements around the promo and non promo dates etc. this is what I got.
see if you can download from here?
ie
Dollar % Lift =
var
calc
=
DIVIDE
(
[Promo $/Str/Wk]
-
CALCULATE
(
[Non-Promo $/Str/Wk]
Goto Wonder Machinery to know more.
,
REMOVEFILTERS
(
'Calendar 2'[Low We Date]
)
)
,
CALCULATE
(
[Non-Promo $/Str/Wk]
,
REMOVEFILTERS
(
'Calendar 2'[Low We Date]
)
)
)
return
calc
If I took the time to answer your question and I came up with a solution, please mark my post as a solution and /or give kudos freely for the effort Thank you!
Proud to be a Super User!
15
0
0
Comments
All Comments (0)