This is exactly what I am looking for!! Thank you so much, JJ! There are many documentation for this but I couldn't find where to start. Glad I've found your video.
Thanks for this, really useful. I have a question, how can it be applied to all pages of the report. Say you have 10+ pages, how can the dynamic link apply to all report pages instead of the page that you have the control on?
Thank you, very elegant approach. The user that received the URL to the report can click the reset button, and view everything, is there a way to control this.
Yes/No By default, there is not method of doing it. BUT You can change the control to have a default of 0000 so if someone hits reset it will display no data. LMK if that makes sense @Ronen - JJ
THIS WAS AMAZING! YOU ARE MY HERO! THANK YOU! Using your instruction, I was able to string together multiple data source IDs and create a very long, but incredibly helpful url! I am still stuck on one other issue, if you have a solution: I have a bar graph that tracks a stat from a game each day, the problem is that sometimes there is more than one game on one day and it adds the stats. I need to keep the stats separate and each game needs to be shown on the x axis as a separate event. Any ideas on how to do this?
Hey Dana! So glad you were able to get some things working! What you can do is add the game name as a breakdown on the x Axis of your bar chart! So you will have dimension of date & breakdown of “game name” or secondary dimension of “game name “ With downloads as the metrics 🤞 Hope that works for you! -JJ
Great! I had much use of this. Is there anyone that has a similiar solution for scheduled emails? It would be great to use that feature. I would like to schedule to email the same report to different receivers with different filters active.
Your information is very helpful. But I am facing an issue. Can you please help? If they click on Reset from the top bar, it again selects all/ selects none. I can hide the top bar initially but then again if they hover, it again comes. I tried using the URL on the embed way. But it is refusing to connect. Please Help
The only way you can hide the top bar is to embed it. But even then it might not be fully "Away" AS for the "Reset" button. One thing you can do it add a default value that is useless "000000" so when it resets, It simply show "no data" Best of luck! - JJ
Hey JJ - this is fantastic. Very timely for my project. Additional question on this: If I need to segregate the report between different clients is there a way to implement some kind of security on it, where clients cannot just change the URL params to view another client's information? I see this option: 'Allow to be modified in report URL' ...not sure if that would help my case. I basically want to create 1 report template and embed it for different clients who can only see their data (we have PHI). Not sure if it's similar to what Gustavo is saying.Thanks!!
Hmmm what we have done in the past is: 1. Create a case statement with a random string to create a "key" so website(.)com = '1boe13ijg', which only I know. 2. Then use the same method which you will use the string for in the URL instead of the actual value. 3. They will still be able to change the URL, but will not be able to find others since you are using a case statement to look for a random string instead of the actual value. I hope you followed that lol, I might make a video in the future on this, but we will see!
@@Vision-Labs I definitely followed! Would the case statement be in the custom report you created for the hyperlink, or just a new field altogether and then create a key/value pair for each client name? I was thinking about something similar as well...create a hash in my database for the client name and pull that through. And curious - you don't think parameters would be helpful here by any chance right? Thanks!
NICE! You are pretty advanced GDS user!!! What I would do for future flexibility is create a new field: This field is your "Hostname Key" or whatever field you are using to differentiate who should see what. This will allow you to easily create logic using regex or 'and' in the case statements. Have the logic be something like when hostname = 'coolsite' then "123ast" If you use a parameter it ould be less flixbly, This would allow you to have two lines which return the same 'Key string" so you can adjust in the future. Then use this Key Value to filter the report.
Hey - circling back on this. So unfortunately, I hit a snag with this solution. which is essentially anyone can modify the URL to access the main report and see all the data. Params by themselves are not sufficient :\ I've reached out for help on the forum. Let me know if you think of any other ideas. Thanks!
I have a problem in which I have to show exclusive categories in a embedded platform. Using your video as an example, I need that USA viewers can only view USA info, vice versa. All in one embedded report, do you have any solution similar to what I'm looking for?
Hey! If you are embedding it in a platform, I would suggest that you use that platform to create the URL parameter which loads within the embed. Might be a little complicated, but theoretically totally possible.
Thanks, I need to build a report where On opening Data is filtered by company. I want to pass parameter value embedded in url. Unfortunately I haven't got video or content on this topic
This has been really excellent. I've noticed that if I set a URL to open a Report with multiple pages, only the first page will be filtered consistent with the parameters. Using report level filters overrides the URL parms on open. Am I trying to do something that is not possible?
Make sure you aren't using publishing as that can throw you off & it's saved a previous version. When the next page opens it will not have those report-level filters working. What you are doing is totally possible! - JJ
@@Vision-Labs Well, thanks. That both encouraging and disappointing because I'm out of in-box ideas. I have ensured that any and all report pages have "Enable viewer filters in report link" enabled (though I have tried toggling them), and I have played with manually and automatically publishing updates. Where you refer to "Saved", I assume you mean that the report is in View mode. I'm am not aware of another form of save. Bottom line is that if I have a single report page I get a [ \parameter string], BUT if I have more than one report then all report pages URLs get some short [/
Good news! The issue is solved. Effectively once you add the report page, you need to expose the control in the viewable area, go to View mode, select the filer value on each page. When you do that the first page URL will present the parms for all pages. That URL may be used as contemplated in this video. Then you can go back into the report and move the control out of the viewable area.
Only if you are using the hyperlink feature within the set up tab can you have something open in the same window. Any link that used they hyperlink() function will open in a new tab.
@@Vision-Labs Can you clarify what is the difference between the hyperlink feature and the hyperlink() function? I thought both were used via creating a new Dimension/Metric field.
@@emilyhowe3751 Hey! The hyperlink function allows you to pull from data sets. Where the feature just allows you to hard code a url or put pages of the report
There are a couple Facebook communities Which discus things! I believe Data Studio Experts is a great one with Ahmad Kanani as a moderator (he rocks) Good luck! - JJ
@@Vision-Labs Hey JJ, thanks for your reply. I still feel it is a little bit complicated to analyze the URL and obtain the parameters. Is this the only way to pass parameters in the URL and generate unique reports so far?
