Creating two dashboards from the same dataset with one extra filter

Creating two dashboards from the same dataset with one extra filter

Hello everyone,

I'm new to Zoho Analytics, so perhaps my approach has been overly complicated but hopefully somebody can guide me in the right direction. I have a dataset of names and each name has 5 values. I have created a chart with a look up filter that allows you to choose a name from the list and it will return the 5 corresponding values. I have then created a dashboard that includes that chart with some additional text for descriptions. So far, so good.

My problem now is that I want to create the exact same dashboard (with the exact same date) for a new audience but I only want to give them the option to look up a subset of the names. So group 1 has access to all names and group 2 only to some names. In my data, I added a new column to indicate which names could be included for group 2. I then created a second chart and applied two filters. First, the username that you want to look up, and second that it's checked to be viewable by group 2. This also still works. The problem arises when I create a second dashboard with the new chart. The chart data will only be available for the usernames that group 2 has access to but the filter at the top will still show all usernames (available to group 1). The only way I can restrict this at the moment is to add a second filter in the dashboard where you choose to only include names for user group 2. But obviously, I don't want to have this filter show, so that the new audience doesn't realize they don't have access to the full data set.

How can I apply two filters in my dashboard but only allowing one filter to be visible for users to change? Or is there a different way where you automatically restrict the filter choice to now show everything?

And am I making this more complicated? Right now I have 1 dataset, 2 charts (same format, chart 2 just has an additional filter), and 2 dashboards (same format but I want to the additional filter to apply in dashboard 2 as well). Given that dashboard 2 is identical to dashboard 1, except that it only shows a subset of the dataset, could I not just create dashboard 2 with access to chart 1 but apply a filter, so that users can only filter specific names from my database?

    • Sticky Posts

    • Announcing Zoho Analytics 6.0 Beta!

      We are delighted to open up the next major version, Zoho Analytics 6.0 Beta! The new version comes packed with a wide range of functionalities for all persona, namely business users, data analysts, data engineers, and data scientists. Zoho Analytics team

    • What's New in Zoho Analytics - August 2024

      Hello Users! We are back with the latest updates and enhancements made to Zoho Analytics. Keep reading to learn more about them. Connect to the data hosted in the cloud without allow-listing the IP addresses Utilize Zoho Databridge to connect to the data

    • We are coming to your city! Zoho Analytics Community Meetup

      Hello, business leaders and data enthusiasts! We are delighted to announce that registrations are now open for the ZUG meetups, and we can't wait for you to be a part of them. Our in-house analytics experts are geared up to lead discussions on constructing

    • Zoho Analytics: 2021 Look Back

      As we start a new year in 2022, here's some of our top moments from 2021. Zoho Analytics in 2021

    • [Customer Talk] PREMO Group's Analyst Interview at Zoho Day 2022

      Premo Group, a 50 year old Spanish Manufacturing Company, has been our long-standing customer with #ZohoAnalytics. They've been using our platform for their end-to-end, unified business analytics solution.  Hear more from Claudio Cabeza, Director at PREMO

    • Recent Topics

    • How to Display a Logo Image on a Public Form?

      I would like to display a logo image in the header of a form. To achieve this, I added an Add Notes field to the form. The code below works perfectly for Zoho users accessing the form. However, when the form is made public, the image does not load properly:

    • Customize Section

      I know it has to be in the themes somewere but where is it that you can change the divider color of a section?

    • Customer Feature Requests

      Like Zoho, we're a software company that markets an SaaS product. We frequently get feature requests that come from the support system. My technicians have a responsibility to listen to our customer requests and add them. Right now the only way to do

    • the expected input type is jsonarray

      I keep getting an error when creating a record in CRM via a Zoho Form. CRM has a pick list field "Type". All Form entries from this form will ALWAYS be "Volunteer", therefore we do not ask them what their Type is. I am trying to use Set Value to create

    • fetch records from analytics table from creator

      I have a creator workflow that I am working in that will compare data from within the app to a table in zoho analytics. Is there a way to fetch a record from Analytics? I have attempted a custom connector with analytics and tried to use it with invoke

    • Remove County field from Customer Address input screen (or allow input to be deleted)

      We are in the USA and have just noticed that there is now a County field in the Customer Address input screen (and maybe other areas of Zoho Books, but this is the one affecting us at the moment). County is not important to our business, and in fact we

    • Card payment surcharge?

      Hi, I would like to offer my customers the ability to pay invoices by card (using the PayPal integration). However, PayPal charges me around 5% to receive a card payment, and I would like to pass on this cost to my customer by way of a card payment surcharge. Is there any way for Zoho Invoice to be set up to automatically add a defined "card processing fee", say 5% of the invoice total, if the customer elects to pay by card? I don't want to add this on to invoice manually, since most of my clients

    • Cant add contact mail. cant find it

      Hi, I am writing a new message and when I enter the contact address that is in my address book, zoho cannot find it. Previously there was no problem. I wrote the first two characters and it shows me all the contact.

    • Customer Parent Account or Sub-Customer Account

      Some of clients as they have 50 to 300 branches, they required separate account statement with outlet name and number; which means we have to open new account for each branch individually. However, the main issue is that, when they make a payment, they

    • Creating a text box background with round corners in Campaigns

      Hello fellow Campaigns users, Is it possible to create a non-square text box? So with rounded off corners. Like the image that I added below. The shadow effect would be cool too, but I guess that would be more difficult (if possible). I suppose this can

    • Image field in custom module

      Hi guy, Is there any hope of adding a custom image field in the custom module? We created a custom module to keep track of assets, and it would be helpful if we could attach an image to the record. Thanks Rudy

    • Team can't view their created ticket through Followed Tickets

      Hello Everyone, in our organization we are new to zoho desk we have multiple teams, and each team handles specific topics and tickets when one of them tries to create a ticket for another team and use followed tickets to view this ticket we get a message

    • Function #61: Automatically add free item to the invoice based on item quantity

      Hello everyone, and welcome back to another Custom Function Friday! During holiday seasons or special promotions, businesses offer deals like BOGO (Buy One, Get One), Buy 3 Get 1 Free, Buy 2 at 50% off, and much more to attract customers. These promotions

    • Use color coding for picklist field values to enhance visual representation

      It's easier and more efficient to manage a large volume of data in a ticket or other custom module records, such as ticket priorities and issue types, when you apply clear visual distinctions through color coding. Color-coded picklist fields allow users

    • Creating a support request / ticket via email to xxx@zohosupport.com

      Is there the ability to create a ticket from an email sent to my support email address (e.g. xxx@zohosupport.com)? For example, I am running a small computer support/service business and I would like to be able to direct potential customers to send an

    • Call transcrition working for ringcentral?

      I don't see anything about what telephony providers can be used. The Zoho support person A said that RingCentral isn't supported. Zoho support person B said that it works, just make sure the call recording link works. Excellent instructions here: Call

    • Setting up CRM for RFP workflow management

      This will be the first time our organization uses an off-the-shelf CRM, transitioning from our homegrown custom solution, and I would appreciate general thoughts on how to get started in general with our workflow using Zoho CRM. The main question: if

    • Introducing Appointment Title Customization

      Hi all, We're delighted to announce an exciting feature, Appointment Title Customization, which you can use to personalize your appointment title according to your business's specific needs and preferences. An appointment title provides a glimpse of the

    • Custom Module

      I've created a custom module in Zoho Recruit for a separate list outside of qualified candidates. On the module, I use First name and Last Name in separate lines. On the top of the module and when I search a person, it only shows the first name at the

    • How to merge duplicate products?

      merge duplicate products

    • Rollup summary for custom module

      Rollup summary feature was introduced almost a year ago: https://help.zoho.com/portal/en/community/topic/introducing-rollup-summary-in-zoho-crm-public-early-access-2023 It does not support custom modules tough and this post aims to track such feature

    • Foreign Currency Bank Account

      I have a bank account in USD zero balance but when i run the bank ledger in my company currency in AED it was shown small balance 1.31 AED , how to make it zero also ,Thanks

    • "Trigger flow for each entry" not working

      I've read this article on how to trigger a flow for each entry in my array. https://help.zoho.com/portal/en/kb/flow/user-guide/create-a-flow/articles/webhook-trigger#Trigger_flow_for_each_entry I cannot get the flow to run for each variant in this JSON

    • migrating from Zoho Invoices (CRM) to Zoho Books

      Good day, I was wondering if there was a easy way to migrate all the quotes and invoices from Zoho Invoices CRM to Zoho Books. We plan to move to using Zoho Books in a few weeks and would like to have all the quotes and invoices from the past 3 years

    • Edit specific job page on carreer site

      Hey, I was wondering how I could change the layout of a specific job page? (when you go to the carreer website and then click on a job listed there). When I go to customization I can edit the carreer website but I seem to be only able to edit the first

    • CRM - Clearing a Subform

      I seem incapable of working out subform functions without assistance.  I've searched, but can't seem to find anything that works. I have a subform that gets filled in when a Zoho Sign document is completed but the fields don't match with the original field values held on CRM (I did have it automatically update, but some fields were being filled in with terrible data, so had to put a stop to it).  There are 4 fields on the subform: Field Name Original Value New Value Update Update is automatically

    • Automatically add a retainer to every estimate

      Hi all, I've been trying to find a way to automatically add a retainer at a set % to every estimate we create and send. So far I haven't been successful, does anyone know of a way to do this? Thanks,

    • Planning Sales visit to local lead, contacts

      Hello, We have our leads and contacts in CRM. One sale is asking me how he can view all leads and contacts (ideally on a map) in a given area (city or country or "region") so he can plan visiting them. What can be done or need to be developed to have

    • Force Sync Contact/Account from CRM to Books

      Hi all. This might not be a common issue to the large portion of the user base here, but for those who dabble and use CRM and Books integration, they know how painful it is that we have to wait for the 2-hour intervals for the records to sync; especially

    • Workflow for "Expenses" module?

      Hi there, over the last 2 years, Zoho Expense has seen tremendous growth and we are happy with it. But, sometimes it is frustrating to see things are being implemented halfheartedly, or so it seems. For example, There is the possibility to create workflows

    • When is partial reimbursement going to be launched?

      Hi there. I saw somewhere that the partial reimbursement feature is in the work. What is the update and ETA of that? Our clients and prospects have been asking us and we agree that that is an important feature to have.

    • IP Address List > Sigma

      We have developed a ZohoCRM extension that utilizes API calls to our server from Deluge scripts and Widgets. Our API server has IP restrictions in place. To ensure successful communication, we require a list of IP addresses utilized by Zoho's platform

    • Zoho CRM Canvas Copy Original Layout

      Hello all, I want to use Canvas to make small changes to certain views, not to make huge changes. Is it possible to copy the original Zoho layout and set-up and start from there? I checked and all I can find are some templates which are far from the original

    • ZOHO Nightmare

      I am writing as a long-time Zoho user who has faced significant challenges implementing your platform for my business. As a New York-based real estate broker, I have invested over $10,000 and nearly two years trying to integrate Zoho CRM with my WordPress

    • Approval system in Books/expenses

      Hi In Books Is there a way to do the following: 1) Submitter to know the balance in Budget/cashflow before sending the amount for approval? 2) Approver to know the same as 1 above? In Expenses, is the above possible?

    • attaching pdf to a bill using REST api

      I'm trying to attach a pdf to a bill using REST and curl. The problem is the example in that section in the API reference document does not show how to actually submit the file. It only shows the headers used. I've been trying many variations of this

    • How to Open .mbox file in Gmail with Attachments?

      Gmail offer users to backup INBOX folder in .mbox file format via Google Takeout Feature. Howver there is no such option to Restore Gmail MBOX. Thus I would like to suggest you to choose an alternate approach i.e. MBOX to Gmail Wizard. This utility will open .mbox file in Gmail with attachments.  Steps to open MBOX file in Gmail are; Run MBOX to Gmail Wizard Click Add File and add .mbox file. Enter your Gmail login credentials. Click Convert button. Finished! This is how you can open MBOX file in

    • How to create comparison time periods like these examples

      In a Pivot Report I would like to be able to select any date range and show a set of metrics for that date range e.g. revenue, orders, units sold. I would then like to be able to compare to the previous period based on the amount of days on the selected

    • Custom fields for calls and an enhanced call creation form

      Greetings, I hope you're all doing well. We're happy to announce a few recent enhancements we've made to Bigin's Calls module. We'll go over each one in detail. Enhanced call creation form in Bigin What is this enhancement about? This update includes

    • Customize user data collection with User Layouts

      Users denote the people in your organization who work on agile projects using Zoho Sprints. You can add them to your workspace and associate them with required projects. Organizations have distinct requirements in collecting user data. Apart from the

    • Next Page