List of companies that did not meet certain dimension and measure criteria

[jblank]

Hello,

I wonder if someone has a hint on getting following:

I need to show companies that did not have certain activities during past 6 month but also had no sales within past 6 months. I started with this here but it does not lead  me to what I need:

aggr( Count({<[Marketo_Activities.activity] = {"-=Activitity 1"+"Activitity 2"+"Activitity 3">} [Marketo_Activities.activity] ),

[Company_Master.Company_Name],)

How would I add the next two conditions?

[nagulurhari]

Hi,

Can you please share the sample data set. You might need to use set analysis with 'p'.

[jblank]

Hi nagulurhari,
Thanks for your response! I´m sorry, I don´t have sample data - this case is still hypothetical.
Basically, what I am looking for is to have a filter dimension that allows following:
IF company had not activity 1 and not activity 2 and not activity 3 within past 6 months and sales = 0 within past 6 months: Engaged. Else Not Engaged.
So that filter should just have two options:

* Engaged
* Not Engaged

Does that make sense?

[mjht]

Load your data, then use preceding loads to flag those companies that had zero sales in past 6 months and those companies that had no activity 1, 2 or 3 in past 6 months.  On the front end in your charts you can use the flag in set analysis.

[jblank · Accepted solution]

Hello MjhtReply

Thanks a lot - that might be what I need to do 🙂