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
- Replicating DIFFPASTWEEK logic in BigQuery
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
Replicating DIFFPASTWEEK logic in BigQuery
Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
07-08-2022 08:27 AM
My current view has a date column and a column with metric 1 (as shown in screenshot). In the Sisense widget front-end, I aggregate the dates as weeks. This sums up metric 1 for all the dates in a week.
I then use the DIFFPASTWEEK function to create a metric that shows the difference between each week. However, I do not understand the DIFFPASTWEEK function well enough and want to recreate this logic in BigQuery. Can anyone please advise on this? Thanks!
Labels:
- Labels:
-
Dashboards & Reporting
0 REPLIES 0
Helpful Links
Recommended Quick Links
- Community FAQs
- Community Welcome & Guidelines
- Discussion Posting Tips
- Partner Guidelines
- Profile Settings
- Ranks & Badges
Developers:
Product Feedback Forum:
Need additional support?:
The Legal Stuff
Have a question about the Sisense Community?
Email [email protected]
