Domo Office Add-In - Relative Date Filters
Hi, the legacy version of the plug-in that our users are widely used to had the ability to do relative date filtering. Unfortunately, the new version does not include this functionality and is hindering our effort to get users to upgrade. Please enhance the new add-in by adding relative date filtering.
Comments
-
Hi @sn_dgalley - thanks for the submission. Happy to look at including something like this, for sure.
As there are many different ways in which you can use the old (and new) addins - Could you tell me a little bit about how you currently leverage those date filters in the old plugins today?
Also, specifically are you referring to the old Excel ones or the Powerpoint ones?
How would you see the relative date filters playing with the refresh (and/or specifically the automatic refresh options Excel has)? I imagine you'd want the date range to adjust and refresh.
Looking forward to hearing back soon! :-)Cadell Falconer
Principal Product Manager0 -
Hi @cadellfalconer, thanks for the reply.
We are specifically referring to the Excel plugin and yes, the goal would be that a user could filter for "previous 3 months" or "previous week" and upon refresh, it would automatically adjust. This is exactly what one department is currently doing with the old version.
0 -
Got it. Thanks @sn_dgalley.
I imagine you'd want to be able to set this on each card in the deck, and/or at the whole document level?Cadell Falconer
Principal Product Manager0 -
@cadellfalconer , well, as we're talking Excel, each sheet, yeah? Or basically, every imported dataset/card/etc. I'm not sure about the whole doc level.
0 -
In the addins, under the "Document" tab of the addins, you can apply filters that apply to all content in the document - I imagine you'd also want to do that for date filters, rather than only having the dates be configurable on each individual Domo object in the document. (Regardless of being Excel, PPT, Word)
Cadell Falconer
Principal Product Manager0 -
@cadellfalconer ah yes, definitely. Thanks!
1 -
Hi!
I agree. I work with the PPT plugin and I have the same issue. The legacy plugin used to have the custom date filter enabled but in the past months it got discontinued as well.
For the O365 plugin, if we could have the ability to customize the date range once all the cards are added into the document (rather than adjusting the dates on every element separately), it would be great!
Thanks!
Sofia
2 -
Thank you for the feedback @dgalley and @alvarezsofia.
I fear we might have gotten a bit mixed up here, so I'd like to clarify and check a few things with you both.
CARDS:- Cards already support the ability to set relative date filters today, during the import of cards, the date box in the top right hand side of the import popup allows you to configure those.
When refreshing you should see those sliding windows move relative to when you refresh the card.
See screenshot below. Are you seeing unexpected behavior with this?
- Cards when adding the date column as a "Filter" do not have relative range support today. If this is what you are referring to, I'd be happy to look at bringing that functionality in, please confirm.
DATASETS:
- Datasets do not have the ability to have relative date filters today, as the date columns when added as "filters" (like point 2 of cards above) don't have that option. As with cards, I'd be happy to look at bringing this functionality in.
DOCUMENT LEVEL FILTERS:
- Again, as above with datasets and point 2 of cards. Happy to bring that functionality to date filters at the document level.
=======
NEXT STEPS:
- Please let me know if the above makes sense and provide me with your thoughts.
- Please also let me know if you are seeing unexpected behavior in regards to point 1 of cards above.
- For "date" or "timestamp" columns when added as "filters" (not the upper right box in the modal):
Would adding the standard Domo date range/relative date options functionality to those column types for datasets, cards and document level filters address your needs?
Example:
Cadell Falconer
Principal Product Manager0 - Cards already support the ability to set relative date filters today, during the import of cards, the date box in the top right hand side of the import popup allows you to configure those.
-
@alvarezsofia @dgalley - Just wanted to follow up on this, did you see my comment above?
Is the only outstanding item here for us to add features as below:
=======
For "date" or "timestamp" columns when added as "filters" (not the upper right box in the modal):
Would adding the standard Domo date range/relative date options functionality to those column types for datasets, cards and document level filters address your needs?
======Cadell Falconer
Principal Product Manager0 -
@cadellfalconer hi Cadell, yes, most of our users are importing datasets rather than cards so adding that functionality is what we're looking for. We are not seeing unexpected behavior with regard to the card import. As you suggested, document-level relative date filtering makes a lot of sense.
0 -
I'll get this scheduled and report back.
Cadell Falconer
Principal Product Manager1 -
Hi Cadell, sorry for the delay on my response.
Yes, I was talking about document level filters.
Cards have the ability to be filtered by date, but our document has over 60 cards so changing the date on every manually on each is inefficient.
So maybe, adding the standard Domo date range/relative date options functionality to the document would solve this :)
Thanks!
Sofia
1 -
I've got this scheduled for the next month or two in our monthly release cadence for the addins.
(Internal Tracking: ID-411004)
I will report back once we roll this out.
Thanks everyone for your feedback.Cadell Falconer
Principal Product Manager3 -
1
Categories
- All Categories
- 1.8K Product Ideas
- 1.8K Ideas Exchange
- 1.5K Connect
- 1.2K Connectors
- 297 Workbench
- 6 Cloud Amplifier
- 8 Federated
- 2.9K Transform
- 100 SQL DataFlows
- 614 Datasets
- 2.2K Magic ETL
- 3.8K Visualize
- 2.5K Charting
- 729 Beast Mode
- 53 App Studio
- 40 Variables
- 678 Automate
- 173 Apps
- 451 APIs & Domo Developer
- 46 Workflows
- 8 DomoAI
- 34 Predict
- 14 Jupyter Workspaces
- 20 R & Python Tiles
- 394 Distribute
- 113 Domo Everywhere
- 275 Scheduled Reports
- 6 Software Integrations
- 121 Manage
- 118 Governance & Security
- Domo Community Gallery
- 32 Product Releases
- 10 Domo University
- 5.4K Community Forums
- 40 Getting Started
- 30 Community Member Introductions
- 108 Community Announcements
- 4.8K Archive