Re: EOMONTH() filter with two differents columns

pandreab · 05-07-2021 07:40 AM

Hi, I’m new in all this but I’m loving it!

I was able to use this filter on my Slice and it’s working :

EOMONTH([Column 1],0)<=EOMONTH(TODAY(), 1)

But now I need my slice to show me one more column using the same row filter, something like this:

EOMONTH([Column 1],0 [Column 2],0)<=EOMONTH(TODAY(), 1) I have one more column that does exactly the same as column 1 but I don’t know how to “call it”

Thanks

Steve

Please describe in pain language what you’re tying to accomplish. I’m not sure what you want.

pandreab

Sure I will try.

I have one table, with that table I created a primary view and that view displays a Slice, that Slice is working perfectly right now with this Row Filter Condition EOMONTH([Column 1],0)<=EOMONTH(TODAY(), 1)

But I just don’t have Column 1, which has a Date format, I also have Column 2 which is a Date format column as well.

Now, I need the exact same Row Filter Condition EOMONTH([Column 1],0)<=EOMONTH(TODAY(), 1) but for Column 2 as well, but on the same Slice. I need to list Data from COlumn 1 AND Column 2 together, on the same Slice. Just need to add one more column to the Row Filter

I know this might not be correct as I don;t know that much about it but I image something like
EOMONTH([Column 1],[Column 2],0)<=EOMONTH(TODAY(), 1)

I hope you understand. thanks

Steve

Please explain it to me like I know nothing about computers. Only explain what the row filter condition is trying to determine.

pandreab

The Row filter condition is trying to determine a list of Cows that are about to give birth This and Next month, all based on the dates that I have on the Source Table in “Column 1”. That’s something I can see right now on the App and that is working.

What I need is to add another column to the Row filter condition, So I can Merge Column 1 And Column 2 dates in just one list.

I hope I’m clear, sorry about that.
Thanks.

Steve

So you want to see if the date in either column 1 or column 2 are in this or next month?

OR(
  ([Column 1] <= EOMONTH(TODAY(), 1)),
  ([Column 2] <= EOMONTH(TODAY(), 1))
)

Or do you want to see if the date in both column 1 and column 2 are in this or next month?

AND(
  ([Column 1] <= EOMONTH(TODAY(), 1)),
  ([Column 2] <= EOMONTH(TODAY(), 1))
)

pandreab

yes like that, if the date in both column 1 and column 2 are in this or next month!

Steve

That’s what that expression does.