95
Views
3
Comments
Filter week and month
Question

Hello,
How do I make a filter to filter how many items are with the date for the current week, and for the current month?
In this aggregate is possible?? in Filter?

Can help me?

2022-08-03 04-32-50
Ravi Punjwani

Hi Pedro,

Can you share your aggregate screenshot so we know what entities and attributes are involved?

UserImage.jpg
Pedro Faria

I need that this value (Picture) filter in this week.

I want to do a count ID about this date in this week.

2022-08-03 04-32-50
Ravi Punjwani

You can add a filter with From and To dates (for the week option) so you can have the data filtered with that period only. Then use the Count group as you've done in second picture.

For the month option, you can use Month() and Year() functions in your filters to show data only for that particular month. This way you won't need to calculate From and To dates in your code.

Community GuidelinesBe kind and respectful, give credit to the original source of content, and search for duplicates before posting.