Learn how to create dynamic dashboards in Google Sheets. This video tutorial will demosntrate examples of skills that will help you create functional and good looking dashboards.
Пікірлер: 119
@PietroGatto6 жыл бұрын
My compliments, you produce the best videos on this topic.
@melihsinantemel3594 жыл бұрын
If you unselect the "Blanks" to remove the zero values while adding a Filter to the Pivot table, statistics won't be updated if you insert new values to your original sheet. Great job btw.
@ExcelGoogleSheets4 жыл бұрын
You are correct. I did show a solution for this using rules in my newer slicer videos.
@brianstokley99185 жыл бұрын
Would've been extremely helpful if you could've linked the tutorial videos you suggested we watch first in the description! That's my only criticism though. You make great vids!
@thaboshikwambane4 жыл бұрын
Here - kzbin.info/www/bejne/enWreoVpesunmq8
@thaboshikwambane4 жыл бұрын
Be the change you want to see in the world.
@brunadovallerodriguesneves37314 жыл бұрын
When I can delete the pivot sheet and when a need just to hide?
@pistolpete74223 жыл бұрын
How do you update the pivot table filter when adding new brands? Mine does not auto-update to include the newest items
@dwihadyan1804 жыл бұрын
4:37 is where it start building it and great video, keep it up!
@brookehoward-smith31186 жыл бұрын
Hi there, have you saved an editable template of this? That would be so helpful
@mage76174 жыл бұрын
DID HE?
@diozhics264 жыл бұрын
It's in the very first video.
@mrmackcomp84052 жыл бұрын
kzbin.info/www/bejne/ZqqwgICJd6qBmNE
@knowledgeworld879411 ай бұрын
You have done a great job. And by using this I've created my own dashboard. But there is a problem. I've used charts there and not able to freeze them at the top. Do you have any solution on this?
@md.tushar99422 жыл бұрын
Why Don't you share workbook?
@bobykumar39604 жыл бұрын
THANK YOU SO MUCH. THANK YOU SO MUCH FOR HELPING.
@macacangan74549 ай бұрын
Question, how do you exclude a grand Total row in Stacked Bar Chart without affecting the pivot table?
@janetchavis20054 жыл бұрын
I love your videos. I would like to ask though, how do I get my sort drop down box to adjust everything in the Dashboard Like you did?
@interesting_stuffs2 жыл бұрын
Is there a video on how to sell subscription in Google Sheets' add on, already? If not, any references would be greatly appreciated. Thanks!
@HYACINTHEGOODWILL9 ай бұрын
Wow! this is great
@mhillchannel62414 жыл бұрын
I can not select A1 to create the DateSet sheet, because of the blue tab with formula in it keeps popping up in front of A1.
@milofungus29823 жыл бұрын
Why do we need to make copy dynamic of dataset into another sheet? What happen if we make dashboard directly from original dataset?
@yashsagar48 Жыл бұрын
Hey where can I find such datasets to practice building dashboards?
@leameanadavis97424 жыл бұрын
would be helpful to link the videos that you have for the functions
@devanshsoni7894 Жыл бұрын
It was very helpful video, thanks
@NinadV-s3l6 ай бұрын
Thank you for the video and tutorials. However, I'm getting the following error: Unable to parse query string for Function QUERY parameter 2: PARSE_ERROR: Encountered " "500 "" at line 1, column 16. Was expecting one of: "(" ... "(" .... Tried removing the entire column but not getting through. Can anyone please assist.
@vinodkumarPrajapativnd4 жыл бұрын
How is it taking maps for states. If name of a state is misspelled then?
@Madhavrajpal1223 жыл бұрын
Simply awesome!
@nightsky19796 жыл бұрын
Great video as usually. One valid remark which maybe should be highlited in video for other users. Once you do filters in pivots to exclude (blanks) it will mean that in case new state or saler_rep will show up in Transactions (during upload new records) will be excluded default at pivots and going to be not included in dashboard. Do you have any solution for that?
@FreedomWired5 жыл бұрын
You can use the filter by condition option and select "Cell is not empty".
@DanteSouzaeSouza5 жыл бұрын
Maybe use a combination of OFFSET and COUNTA for the Pivot Table Range.. Idk if it will work in Sheets. I used to use this in Excel. This would make the range end the actual data end and discard the blanks
@DanteSouzaeSouza5 жыл бұрын
Found this: infoinspired.com/google-docs/spreadsheet/dynamic-ranges-in-google-sheets-without-helper-cell/
@AnilSharma-ht1kh4 жыл бұрын
how it is linked with start date and end date
@mohamedaydarous96374 жыл бұрын
Hi, great video, I benefited a lot. Thank you very much I have one problem When creating a Pivot Table I find a message in Pivot Table editor "sorry there are no suggestions for this table" Thanks for your support
@mohamedaydarous96374 жыл бұрын
you are welcome, thanks for your support @Brain Out
@eehangsin44634 жыл бұрын
Where can I get your sample data
@Phani_IND4 жыл бұрын
Nice!
@anugrahandi6 жыл бұрын
Thank you. Great explanation.. but why it needs to use query (TempDataSet)?
@ExcelGoogleSheets6 жыл бұрын
You'll understand why if you watch part 2, part 3.
@hassanarafa31854 жыл бұрын
keep the good job up man
@danish17945 ай бұрын
where to get the dataset
@MichaelGonzalez-bw9cu4 жыл бұрын
Nice content, I am new to excel and would like to create my own dashboard. Do you have a tutorial that can help me create a survey tracking dashboard? not by ranks but tracking number of survey returns.
@Infinite_Dreamer__3 жыл бұрын
I followed the same steps in the video but after pasting the last step in query .. I am getting error invalid date literal. Sir/madam .. can u help please
@mohammedrabiusalifu90674 жыл бұрын
please where can I access the part 2 tutorial?
@queenkai95222 жыл бұрын
Very helpful. Ty
@DMARINIMARTINI5 жыл бұрын
great simple instruction
@96592214436 жыл бұрын
Everything I understood but how did u made tat region table
@lmiguedp4 жыл бұрын
Where to start? I see the Intermediate and advance courses of Google Sheets but not the beginners one
Hi! I tried but I am getting error stating "unable to expand as the data overwrite in E7". can you please help me out ???
@DronesAhead6 жыл бұрын
Hi buddy, thanks for your tutorial. I have a doubt. I have a form that is already filled with information. I would like to create a simple interface where I can put a key word and the program find or no that word and show the results. is the same CTRL+F, but I would like to show on the screen, all information that the program found. Do you have some clue about it please? Thanks
@ExcelGoogleSheets6 жыл бұрын
VLOOKUP function seems to be what you are looking for. I have a lot of videos covering that function. Watch part 1 VLOOKUP.
@ThaoTran-dj8rs3 жыл бұрын
can you upload the demo sheet?
@renatocastillojr77036 жыл бұрын
Hi. Thanks for the video everything is working but when I combine the formula all together it is not working, it's not pulling up the date based on the dropdown list except for the option "All" Can you help me? This is what my formula looks like on the temp sheet: =Query(Master!A1:N,"Select A, B, C, D, E, F, G, H, I, J, K , L, M" & IF(COUNTBLANK(HelperFormulas!A1:A3)=3,""," Where " & TEXTJOIN(" AND ",TRUE, HelperFormulas!A1:A3)),1)
@thantoo61505 жыл бұрын
If you don't mind can you share this data file which can be done by practice
@pawegorczynski65216 жыл бұрын
It would a nice to provide the data set you're using... in case someone wants to follow the tutorial himself :)
@renatocastillojr77036 жыл бұрын
Agreed.
@AnjanaLakshan-x6uАй бұрын
Can you send this data set
@hdjotaniya6 жыл бұрын
how to add any stock previous day high low data in Google sheet Google Finance im try too much formula but not work please help thank you
@digiratimax5 жыл бұрын
Thank you for the clear tutorial
@suchithraab85153 жыл бұрын
how to show this dashboard in html page?
@sakshishinde93379 ай бұрын
Can you plss provide the dataset?
@caseygoodrich81195 жыл бұрын
Can this be exported to excel?
@ansonlobowolf6 жыл бұрын
How did you copy the Pivot Table from one sheet to the other. When I try it at my end it seems to copy only the values. Any changes in the original Pivot does not reflect on the Pivot I have copied to the new sheet.
@ExcelGoogleSheets6 жыл бұрын
You have to make sure you select eh whole pivot table. If you miss a part of it it won't work. Otherwise it should be just copy/paste, nothing special.
@josephjesusflorianflores70893 жыл бұрын
@@ExcelGoogleSheets Can you share the demonstration with me?
@phongvo99893 жыл бұрын
tks so much bro!
@Adrian-0295 жыл бұрын
Hi, new subscriber here! :) One question, why is there a need to create a TempDataSet? Can I go straight to the Main sheet? Tnx ;)
@ExcelGoogleSheets5 жыл бұрын
If you want to to what I do in Part 2 then yes, otherwise no.
@josephjesusflorianflores70893 жыл бұрын
@@ExcelGoogleSheets Can you share the demonstration with me?
@johncipolla8335 Жыл бұрын
I want to be able to extract data from a radio button from data that is on another sheet
@ogunladesamuel41052 жыл бұрын
can I get the link to the raw data ?
@mandalakomputer3468 ай бұрын
Thanks
@AJZam994 жыл бұрын
Hi, would gladly appreciate it if we can have the raw dataset for this video? :))
@abhinovize3 жыл бұрын
1++
@eliekareh50856 жыл бұрын
Hi , I did the same example and it gives me an error message , the message is : Result was not automatically expanded , Please insert more rows (10336) formula is =QUERY(Transaction!A1:Q," SELECT *",1),, can I have your comment please , thanks.
@ExcelGoogleSheets6 жыл бұрын
the number of rows available in the sheet is less than rows from query results. you need to create enough rows in the target spreadsheet to fit the results.
@eliekareh50856 жыл бұрын
Hi, I select the exact data existing in the sheet , =QUERY(A1:R25222," select * ",1)and i get another error message : Circular dependency detected. To resolve with iterative calculation, see File > Spreadsheet Settings. in the spreadsheet settings i choose united state and GMT +2. what can I do ? sorry but it doesn't work .
@sitiriyani71994 жыл бұрын
thank you
@PatrickJonas6 жыл бұрын
Description Explore educational videos about our products. For additional help visit our help centers and communities at support.google.com
@josephjesusflorianflores70893 жыл бұрын
Can you share the demonstration with me?
@AbhiJeet-my9oo6 жыл бұрын
Hey you skipped the major filtering parts, ie- region and start & end date that are needed to be linked to filter the whole dashboard!
@ExcelGoogleSheets6 жыл бұрын
it's a 3 part tutorial. make sure you watch part 2 and part 3.
@madhukaranand61394 жыл бұрын
can you provide the raw data
@khemrajrana73224 жыл бұрын
Dear sir please update new video for Google form automatically update work
@sergheyzaporojanu6872 Жыл бұрын
he merged the cells = closing this video 🤣 never coming back to this chanel
@ExcelGoogleSheets Жыл бұрын
Cool!
@kazitanjil89702 күн бұрын
For those wonder "Pivot table" is under "Insert" and not "Data".
@rogerhartley66304 жыл бұрын
Thanks for these video, they are really helpful. I am trying to workout how to show some data on a dashboard that is drawn from a pivot table. I can't find a way to get the chart to show what I need using teh master data, it is only available from the pivot tabe I created. However when I then try to add slicers i am unsure how to get them to work across the whol data (both tables and charts that are taken from the master data and the pivot chart). Any suggestions?
@dacx66 жыл бұрын
Great video. I just have a question. Why do you have to create the "TempDataSet" tab? Why not just use the "Transaction" tab data for your "Dashboard"? Thanks.
@ExcelGoogleSheets6 жыл бұрын
Part 3 has the answer to your question. I use it for a dropdown filter.
@dacx66 жыл бұрын
Thanks @Learn Google Spreadsheets
@moschides5 жыл бұрын
@@ExcelGoogleSheets great skills...
@AbdullahSwapon Жыл бұрын
Could you share the excel file for better learning?
@jay_with_the_real63812 жыл бұрын
Is the data available somewhere to follow along?
@francelinoximenes32814 жыл бұрын
Hi...there. Why the average of pivot table and TempDataSet is different? Thanks
@maibernardo8740 Жыл бұрын
How can i put the google data studio dashboard in google sheet?
@vijayalaxmi9983 Жыл бұрын
Do you have day time live sessions? I work in night shifts
@KahkeshaFirdous Жыл бұрын
how to get all data filter as per date like monthly and weekly
@solusidarilangit4 жыл бұрын
i am trying this...and then i find that if there is new region or brand....it is not appear...filtered
@ExcelGoogleSheets4 жыл бұрын
check this for a solution kzbin.info/www/bejne/iXbdfIyFntWnec0
@ExcelGoogleSheets4 жыл бұрын
instead of filtering out blanks, use condition "not empty"
@solusidarilangit4 жыл бұрын
@@ExcelGoogleSheets i see.... thank you master.... next is what about making a chart based on transaction date.... but not everyday has transaction...i want the date to appear in the chart with 0 instead of skipping the date
@iputukurniawan2764 жыл бұрын
if i need 2 filter criteria in Region Box. Example : i need data in region Southern and Western. How to make that?? Thx U
@ExcelGoogleSheets4 жыл бұрын
Watch my QUERY function series kzbin.info/www/bejne/mIiZgWWPq7GskMk
@jimmylambMUSIQ4 жыл бұрын
@@ExcelGoogleSheets couldn't actually find this solution in any of your videos. seems like it'd need a script and then some reconfiguring of the query formula to get it done. looking for the same deal: multi-select in those dropdowns to filter the query sheet. my answer may be move to google data studio. thanks!
@ExcelGoogleSheets4 жыл бұрын
@@jimmylambMUSIQ There is no multii-select dropdown in Google Sheets. You just have to use separate dropdowns. Or just use Data Studio, as you already said.
@igormendes54924 жыл бұрын
Amazing! Thank you so much for the content you produce!
@arnoldgerry20544 жыл бұрын
Very helpful indeed Thank you so much
@lukethis29245 жыл бұрын
Hey. My pivot table is not automatically updating. I have removed all filters. Can anyone help please?
@Basanti_Gabbar3 жыл бұрын
Need to right click on the pivot data and select refresh.