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:

Read more

1. 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.---------

2. 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.

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

Proud to be a Super User!