I was able to make a version that works based on your suggestions.
DO you have any ideas on how to make the updating of the dashboard any faster? It takes a couple min to get the filter data to pull into the reports and the dashboard.,
Have you tried the below?
Also I made a note on dashboard:
I recall seeing the same thing and have been searching high and low for the answer. I don't know if the Officeworks Administrator is in this community, but we'd all love to find out how you were able to achieve this.
I would be very interested in the answer to this too :)
This would be a great feature
I'm in support of this enhancement request. The filters at dashboard level should help minimize the number of dashboard clones with varying filter criteria.
Following options to be considered:
1) dashboard filter dropdowns - selecting a filter criteria from one or more drop down filters. The widgets on the dashboard should be configurable whether to reflect the filter criteria or not.
2) filtering by selected value (s) from the displayed data set - selecting an item ( or more) from data set ( e.g. Country = UK) will focus the widgets on the resulting subset of data meeting the filter condition. If the widget behavior is set to open the source report , then this report should be opened with filtered data set.
This would probably require a newly designed filter definition and grouping logic being part of the dashboard definition.
I propose the implementation of a new feature that allows us to filter data directly from the dashboards, eliminating the need to switch back and forth between dashboards and reports for filtering purposes. With this enhancement, we can streamline our data analysis process and save valuable time while gaining deeper insights into our projects.
In addition to the filtering comments by Dan and Amanda, also being able to filter by widget name would be an asset. That way leaders could look at department level results by category. This would be helpful as a focussing tool. My suggestion is to be able to add widgets to a filter category at the dashboard control level. This could the filter by team, subject or other criteria. The dashboards can become very large when you are trying to wrap up lots of different categories of information, so being able to adjust the dashboard size (by focussing by filters) would be much more user friendly. All the other comments have real value as well, especially the tailoring of the dashboard branding. This then also leads to the inability of any tailoring for Dynamic Views. Currently, font style, colour and fill options are not available. Any items used on the dashboard should be able to be uniformly presented. We also use dashboards to present to non employees via Dynamic Views.
Dashboards need integrated filtering to quickly condense the displayed info. I.e please make the report tables and graphs displayed on the dashboard active within the dashboard, so we dont have to navigate to the original report. The lack of function to do some simple data exploration in the dashboard feels as though it depletes the point of a dashboard.
For example, we display journals publications that can be shown via reports and graphs on the dashboard. But it would be much more intuitive to then be able to filter these reports/graphs on the dashboard to show, for example, top publishers to a particular audience and/or in a particular field.
Creating separate reports and dashboard for all combos of categories is not plausible, as it creates hundreds of reports, and creates a messy dashboard.
This feature...would be amazing. Currently we attach Tableau dashboards to Smartsheet ones because it has dynamic filters...would be cool if Smartsheet ones did. :<
Agreed -this feature would be amazing! My team needs to filter by product for supporting each product. We don't have any additional tools at my company so using Tableau is not an option.
Hello, I want to create a dashboard to provide project information. But have the ability to select the project from a drop-down list, rather than having to move to different project dashboards. This will allow easier navigation for portfolio stakeholders.
Can this be developed pleaase
Pasting my comment from another thread here since the other thread isn't monitored by the product team:
This functionality seems like it would be table stakes. We're currently building out stopgaps in Tableau (which is not repeatable for most teams we work with).
A one-stop-shop with the ability to filter between workstreams would be helpful... especially when you've got 10+ workstreams per program and multiple programs. I understand the opportunity to up-sell features/products, but this lack of basic features can turn SmartSheet into a hard sell.
I'm glad to submit a request and upvote this post, but if there's any indication as to whether this feature is being considered on the near-term roadmap, I would appreciate it.
Link to related thread - Dashboard with Filters - Best Practice — Smartsheet Community
@Francisco This thread isn't monitored by the product team either. I'm pretty sure we're all sent here to air our ideas and to make us feel like we're contributing, but in reality they just fade away.
Hi Community, Welcome to the Product Feedback and Ideas space where you can help shape the future of Smartsheet! We really appreciate your feedback and will take all posts into consideration. Our product team will review top ideas and requests monthly and we'll share updates as soon as we get them. Remember: if you have a…
When a project and tasks are set up with dependencies and durations, the project manager should be able to drive all task dates based on the project end date, not just the start date. Often mid project the delivery date needs to be changed. With Smartsheet, a project manager needs to adjust the duration of all tasks…
It would be great to be able to select a workspace as the template source folder while setting up a blueprint in Control Center. Currently you have to select a folder in a specific workspace. This change would eliminate the initial folder created at the workspace level, and would allow the end user to have all the template…
Currently, when cell links are created, the updates have to originate from the source cell, and then propagate through the subsequent links. Particularly in a Control Center setup, you can have 3 or more sheets that link (from the intake sheet, to a metadata sheet and then to the project plan, is one example). As an…
©2023. All Rights Reserved Smartsheet Inc.