This website uses Cookies. Click Accept to agree to our website's cookie use as described in our Cookie Policy. Click Preferences to customize your cookie settings.
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results forย
- Community
- Legacy Discussions
- Build Analytics
- How to filter out dates past the current date
Options
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
How to filter out dates past the current date
Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
โ06-27-2022 10:47 AM
Hi! I have one metric here that is using the PREV() function to get data from 4 weeks ago. Hence, the date rows go all the way to 4 weeks in the future here. I have included a widget filter called current_date_flag, which is basically a row in my EC view that checks whether a date is larger than the current date. However, this filter does not seem to be working. Is this because the PREV() function overrides it? Any help would be appreciated!
Labels:
- Labels:
-
Dashboards & Reporting
-
Data Models
0 REPLIES 0
Community Toolbox
Recommended quick links to assist you in optimizing your community experience:
- Community FAQs
- Community Welcome & Guidelines
- Discussion Posting Tips
- Partner Guidelines
- Profile Settings
- Ranks & Badges
Developers Group:
Product Feedback Forum:
Need additional support?:
The Legal Stuff
Have a question about the Sisense Community?
Email [email protected]
Related Content
- Time periods by specific day of month (e.g. first Friday, Second Wednesday) in Build Analytics
- Date Filters - List in Build Analytics
- Dynamic (WTD, prior WTD) based on selected Date Filter in Build Analytics
- Customizing a filter in Build Analytics
- Date filters - possible to have fixed start date, lagged end date? in Build Analytics
