Dashboard Page Filter bar - limit the filterable columns

Seth
Seth Member
in Cards, Dashboards, Stories

Hi, I'm trying to find out if there is a way to only limit the filter in the filter bar to a pre defined set.

USE CASE

I have a data set that contains private data.

I want to use that SAME dataset on 2 different dashboards.

Dashboard 1, you would see all the columns so you can filter

Dashboard 2, you would only see a defined set of filters.

For example, in the screenshot below, I would want to hide admissions_email from Dashboard 2

Screen Shot 2023-05-11 at 6.44.45 PM.png

Is there another way I can achieve this without having 2 datasets?

thanks!

Best Answer

Answers

  • DashboardDude
    DashboardDude Coach
    Answer ✓

    Hi @Seth ,

    One thing you can do is just make a card as a filter and then take out Admissions_email as an option in dashboard 2.

    I made you a video to show you: https://www.loom.com/share/b3e72a2b72084aca85929b6b26f65ac3

    Circle.png

    John Le

    Are you on my newsletter? If not, signup here so you don't miss out on my Domo tricks, alerts about my webinars, cooking tips and more

    Signup here:

    https://www.dashboarddudes.com/newsletter

  • Seth
    Seth Member

    Hi DashboardDude!

    Thanks for the video.

    So if basically wanted them to be able to filter to a depth of 3, then I would just put that filter on 3 times, and not show the page filter bar or let them drill down to the data set correct?

    Is there any other way? As I'm sure you are aware, each one of those cards are an "Impression" on an embed dashboard. So it will have a cost of 4 vs a cost of 1, if I am able to use the page filter bar. Those costs add up fast!

Categories