Variable Response in Beast Mode

Scrapper140
Scrapper140 Member
in Beast Mode

In the Beast Mode below, End Date 2, Start Date 2, Measure Selection and Client Select are all variables. For the Measure Selection and Client Select, is there an alternative to hardcoding the literal value for each Client Select & Measure Selection permutation? Is there a way to take the variable response and feed it into the beast mode?

SUM(CASE
WHEN Date <= End Date 2 AND Date >= Start Date 2 AND Measure Selection = 'Clicks' AND Client Select = 'Acme' THEN CASE WHEN Benchmark Client Groups LIKE '%Acme%' THEN Clicksend

WHEN Date <= End Date 2 AND Date >= Start Date 2 AND Measure Selection = 'Revenue' AND Client Select = 'Acme' THENCASE WHEN Benchmark Client Groups LIKE '%Acme%' THEN Revenueend

WHEN Date <= End Date 2 AND Date >= Start Date 2 AND Measure Selection = 'Clicks' AND Client Select = 'Beta' THEN CASE WHEN Benchmark Client Groups LIKE '%Beta%' THEN Clicksend

WHEN Date <= End Date 2 AND Date >= Start Date 2 AND Measure Selection = 'Revenue' AND Client Select = 'Beta' THENCASE WHEN Benchmark Client Groups LIKE '%Beta%' THEN Revenueend

ELSE 0
END)

                

                        

            Tagged:
            
        


            
            

        

    




            
    
                            

            
    

                                

                                

                                
                                

                                        
    
    


        
Categories