Alteryx Designer Desktop Discussions

timol · ‎03-28-2021

Dear all

I have the following data structure

Now I want Alteryx to give out a count for each year 2015-2020

But it should only count of Year 2 os lower of equal to Year1

So that would be the output

Can anyone help me doing this in Alteryx?

afv2688 · ‎03-29-2021

Hello @timol ,

would this workf for you?

Regards

timol · ‎03-29-2021

@afv2688 Thank you so much!!!

Do you also have such a solution for the following data structure:

afv2688 · ‎03-29-2021

Hello @timol ,

How about this?

Regards

timol · ‎03-29-2021

Thank you @afv2688

I tired to implement the workflow in my case but it does not work (I am not capable of implementing...)

One addition to the previous table

I always want to show the timespan from 2013-2018 except if the founding of the company is later than 2013 (e.g. 2015). Then I want to show 2015-2018

Do you have an idea how to do that?

OllieClarke · ‎03-29-2021

Hey @timol very similar to @afv2688's previous solutions, but this should do what you're after:

afv2688 · ‎03-29-2021

Hello @timol ,

Adapted the solution to your needs.

Let me know if you need anything else,

Regards

timol · ‎03-29-2021

Thank you

But the value for company A in 2018 should be 11 right?

timol · ‎03-29-2021

Thank you!

But for company A the timespan should start with the founding year 2013 right?

afv2688 · ‎03-29-2021

Hello @timol ,

Here you go. Based on your perrequisites (year2 <= year1 it shouldn't)

Another thing would be if we have to add the 2017 data to the 2018, calculations would need then to be different (and even then it would be 10).

If that is the case, I also added another workflow.

Regards

COUNTIFS