Carrying date range in hyperlink
I am using pfilters to drilldown on multiple columns. But the set date range isn't carrying when the link is clicked. How can I open an anchor link so the new page has the date range the first page had?
CONCAT('<a href="https://domain.domo.com/page/1234567898?pfilters=' etc
** Was this post helpful? Click Agree or Like below. **
** Did this solve your problem? Accept it as a solution! **
Best Answer
-
Beast Modes have no sense of the global date filter on the page so you can't set it to whatever is currently filtered. You may be able to leverage a custom Domo Brick and some javascript to attempt to get the filter options when the filter occurs with the onFilterUpdate event handler.
More information on this can be found here:
**Was this post helpful? Click Agree or Like below**
**Did this solve your problem? Accept it as a solution!**0
Answers
-
Here's the Domo knowledge base article:
, but I'm not sure if you can use dates there. Do you have example code?0 -
I use a concat like the one above but my screen has confidential data I cannot show.
My link works just fine…it opens the page and performs filters on three fields. The problem is..my original screen is a summary, and the user can set the date filter. And I don't know how to carry the date to the next page.
Assume the following image represents my report. On the left, the first page with the summary amounts. Clicking office 002, production 4 will take you to another page (aka image on the right) to show the breakout of the amounts. If the filter doesn't carry over the date range, the details screen won't limit the dates to match the original page.I'm referring to the date range setting in the top right of a dashboard
** Was this post helpful? Click Agree or Like below. **
** Did this solve your problem? Accept it as a solution! **0 -
My concat statement looks something like this (redacted to show different field names)
<a href="https://mydomain.domo.com/page/***********?pfilters='
CONCAT('
,'%5B%7B%22column%22%3A%22office_id%22%2C%22dataType%22%3A%22string%22%2C%22operand%22%3A%22IN%22%2C%22values%22%3A%5B%22',`office_id`,'%22%5D%7D%2C'
,'%7B%22column%22%3A%22author%22%2C%22dataType%22%3A%22string%22%2C%22operand%22%3A%22IN%22%2C%22values%22%3A%5B%22',`author`,'%22%5D%7D%2C'
,'%7B%22column%22%3A%22customer%22%2C%22dataType%22%3A%22string%22%2C%22operand%22%3A%22IN%22%2C%22values%22%3A%5B%22',`customer`,'%22%5D%7D%5D'
,'" target="_blank" title="Open in Domo"></a>','Details','')
** Was this post helpful? Click Agree or Like below. **
** Did this solve your problem? Accept it as a solution! **0 -
Oh I see what you mean. I'm not sure if you can pass date grains via pfilters but I don't think you can
0 -
Beast Modes have no sense of the global date filter on the page so you can't set it to whatever is currently filtered. You may be able to leverage a custom Domo Brick and some javascript to attempt to get the filter options when the filter occurs with the onFilterUpdate event handler.
More information on this can be found here:
**Was this post helpful? Click Agree or Like below**
**Did this solve your problem? Accept it as a solution!**0 -
Wow….that's a significant thing for Domo leave out. I should not have to create all kinds of work arounds like bricks for a simple thing like maintaining the date range.
** Was this post helpful? Click Agree or Like below. **
** Did this solve your problem? Accept it as a solution! **0 -
@GrantSmith is there any update on this? I have a parent page that hyperlinks to several child pages and I need to be able to carry over the global date filter. Users are very confused by seeing a completely different date range when clicking through to a child page.
0
Categories
- All Categories
- 1.8K Product Ideas
- 1.8K Ideas Exchange
- 1.6K Connect
- 1.2K Connectors
- 300 Workbench
- 6 Cloud Amplifier
- 9 Federated
- 2.9K Transform
- 101 SQL DataFlows
- 622 Datasets
- 2.2K Magic ETL
- 3.9K Visualize
- 2.5K Charting
- 748 Beast Mode
- 59 App Studio
- 41 Variables
- 686 Automate
- 176 Apps
- 453 APIs & Domo Developer
- 47 Workflows
- 10 DomoAI
- 36 Predict
- 15 Jupyter Workspaces
- 21 R & Python Tiles
- 396 Distribute
- 113 Domo Everywhere
- 276 Scheduled Reports
- 7 Software Integrations
- 125 Manage
- 122 Governance & Security
- 8 Domo Community Gallery
- 38 Product Releases
- 10 Domo University
- 5.4K Community Forums
- 40 Getting Started
- 30 Community Member Introductions
- 109 Community Announcements
- 4.8K Archive