Filter data by month

Im new here… thanks before helping me…

i have data from jan 2020, buat i wanna filter by month, they only show this month data…
how to do that ???

thanks for helping me…

Hi @Telpro, if I understand correctly from your short explanation above, your intention is to show this month data from your Data table.

If that is true, you may want to to create a Slice from the DataTbl and use below expression at the “Row filter condition”:

MONTH([YourDateColumn])=MONTH(TODAY())
2 Likes

I would suggest this expression instead:

EOMONTH([YourDateColumn], 0)=EOMONTH(TODAY(), 0)

The EOMONTH() function provides the date of the last day of a month, whereas MONTH() just gives the month number. April 2019 and April 2020 are both month 4, but clearly different months. Using EOMONTH() avoids that.

See also:


3 Likes

Thanks @Steve for the correction, I did not consider about the “Year”… still learning…
:wink:

1 Like

ok guys thanks for ur help,

nah can i filtered it by week ? i mean number of week in every month…

It will be depend on what you want to achieved. Is it every week show different data for that week or you want to have a weekly tabulation of data view or some other things?

1 Like

i wanna add new tab that show week number for my data, what is the best solution for this ???

What do you mean by “new tab”?

1 Like

sory, i feel still using sheet,
i mean new view, so in that view i can show week number of the month, is that possible ?

To show week number of the month you can use the WEEKNUM() expression. It will depends on your needs, you might want to use a virtual column or a new column in your table using the App Formula.

However, If you want to create a slice for weekly view (in addition to monthly view), you can use this:

WEEKDAY([YourDateColumn]) = WEEKDAY(TODAY())

And you might want to take a look at below help article:

1 Like

thanks guys, im gona try it…

WEEKNUM() is going to have the same problem MONTH() had: it can’t differentiate years. And again, the fix is to find a common date. The following will tell you if the YourDateColumn column value contains a date in the same week as today:

((TODAY() - WEEKDAY(TODAY())) = ([YourDateColumn] - WEEKDAY([YourDateColumn])))

WEEKDAY(some-date) gives a number (1 to 7) indicating the day of the week (Sunday to Saturday) on which the given date falls. Subtracting that weekday number from that same date gives the date of the date of the last day of the preceding week (the preceding Saturday). Two dates that have the same last day of the preceding week are in the same week.

See also:

2 Likes

Thanks, Steve.

Wouldn’t it better to also include you response like this to the help article? Without your reminder, other like me will just “think short”. :face_with_monocle:

While we are on this WEEKDAY(), I am a bit confused with the Return Value from the article as below snapshot:

If Contains recognizable date, Sunday is 1 other time Sunday is 0, what is recognizable date?

1 Like

Recognizable dates:

  • TODAY()
  • "3/26/2020"
  • DATE([DateTimeColumn])

Not recognizable dates:

  • ""
  • 4200
  • TIME([DateTimeColumn])

In other words, WEEKDAY() returns 0 if given invalid input. Maybe I should just put that…

1 Like

Done.

2 Likes

:scream: :scream:

You can complete updating the help article before I could ever finish my thank-you response to you…

Thanks again, now it is very clear to me.

2 Likes

Nah im confuse guys :sweat_smile:

Now whats the method to use ?

((TODAY() - WEEKDAY(TODAY())) = ([YourDateColumn] - WEEKDAY([YourDateColumn])))
3 Likes

its for show week number right ? how to show last week filter then?? is that possible

for my reference pls add for today too…

thanks for ur help sir,

Please describe what you’ve tried so far with the given expressions and let us understand your difficulties for us to be more helpful for you.

1 Like