I am simply loving that course. I have one question regarding the joins in the physical table: 17:27, when you did the joins the number of rows was increased (I assume it is because of multiple matches between the different tables, leading to duplicate rows in the "one" table in a "one to many" relationship). The question is: when we aggregate measures from the one table, will they be aggregated considering the duplicated rows, or the aggregations will be performed at that table level?
Yes, when you aggregate on measures from the "one" table, they will be aggregated considering the duplicates generated by the join. In other words, the aggregations (sum, average, etc.) will be performed on the values of the duplicate rows, not just on the unique values of the "one" table. To avoid this unwanted behavior, you need to make sure that your aggregations are done correctly, perhaps using LOD (Level of Detail) calculations or other techniques to ensure that the aggregation is performed at the level of the "one" table and not on the duplicates created by the join.
Check your view sheet, bottom right, you should see something like 11 unknown, click it. It will show you all the states and it would say unrecognized. Above it should be something like location, not sure again. but it would show you your current country location. you have to change it to united states to see the colors as represented in the video.
actually i could not save this mean which are prepare sheet practice in my desktop either u use trail version well my are public desktop version i dwnload what i do?
Getting a Bad Connection error when I try to click on map from the show me section. An error occurred while communicating with the Tableau Data Extract data source 'GeocodingData' Bad Connection: Tableau could not connect to the data source. Error Code: AC0843EA Could not start Hyper: Failed to start a new Hyper instance. Context: 0x86a93465 Caused by: The Hyper server process exited during startup with exit code: 1
Child process' stderr: Unable to open log file: SetFileInformationByHandle(): The cloud file provider is not running. FileListener in error state after initial rotate()
Check the hyperd log for more information
Context: 0x13cead20 Unable to connect to the Tableau Data Extract server "". Check that the server is running and that you have access privileges to the requested database.
In Menu Bar, go to Map -> Edit and play with settings there. I am from Germany and none of the maps used to load. By changing some settings had it all sorted out.
Hello Nong! That data source is included when you download Tableau. You can also download the file here: community.tableau.com/s/question/0D54T00000CWeX8SAL/sample-superstore-sales-excelxls
Exercise Files: learnitanytime.com/p/exercise-files-tableau-basics-beginner-tutorial
The BEST tutorial on Tableau on RUclips! Thank you very much, you are really one of your kind. Thank you again!!
You're very welcome!
Thank you for this course ❤
You're so welcome!
I am simply loving that course. I have one question regarding the joins in the physical table: 17:27, when you did the joins the number of rows was increased (I assume it is because of multiple matches between the different tables, leading to duplicate rows in the "one" table in a "one to many" relationship).
The question is: when we aggregate measures from the one table, will they be aggregated considering the duplicated rows, or the aggregations will be performed at that table level?
Yes, when you aggregate on measures from the "one" table, they will be aggregated considering the duplicates generated by the join. In other words, the aggregations (sum, average, etc.) will be performed on the values of the duplicate rows, not just on the unique values of the "one" table.
To avoid this unwanted behavior, you need to make sure that your aggregations are done correctly, perhaps using LOD (Level of Detail) calculations or other techniques to ensure that the aggregation is performed at the level of the "one" table and not on the duplicates created by the join.
Thanks a lot, you are really detailed and easy to understand.
You are very welcome!
❤❤ thank you for taking the time to do this live!
You are very welcome!
at 22:07 did you add "ship state/province" to both columns and rows?
Excellent training. Thank you!
Glad you enjoyed it!
At 22:30, I dont see the my colored for the states - its all blank
Check your view sheet, bottom right, you should see something like 11 unknown, click it. It will show you all the states and it would say unrecognized. Above it should be something like location, not sure again. but it would show you your current country location. you have to change it to united states to see the colors as represented in the video.
@@michaeloyebisi1815 thank you for your great answer
@@michaeloyebisi1815 thanks a lot! this helped!
Thanks for explanatory video. How many module do you have in all?
34 for this video
Great Course!
Glad you think so!
A decent job! Thanks!
Glad you liked it!
this map don't working for me i did evrythink like in a guide but i don't see the collors on my map
Tableau Public is unable to open the accdb file. Access 2007 cannot recognize the database format. How do I proceed from there? Thank you.
This course was created using the Desktop version of Tableau. Tableau Public only supports a limited amount of file extensions.
@@LearnitTraining Would you be able to share the same accdb file data in csv/excel file format so that tableau public can read it?
actually i could not save this mean which are prepare sheet practice in my desktop either u use trail version well my are public desktop version i dwnload what i do?
tableau does not support Microsoft Access files when using Mac..so I am stuck in the northwind file😥
Yeah unfortunately Microsoft never released Access on Mac
Thank u 👍
Welcome 😊
actually those who not use trail version cnt seem similer like outline of usa map why not u use public version for teach us
the best lesson i have ever learned :v
Thank you for the kind words!
Getting a Bad Connection error when I try to click on map from the show me section.
An error occurred while communicating with the Tableau Data Extract data source 'GeocodingData'
Bad Connection: Tableau could not connect to the data source.
Error Code: AC0843EA
Could not start Hyper: Failed to start a new Hyper instance.
Context: 0x86a93465
Caused by:
The Hyper server process exited during startup with exit code: 1
Child process' stderr:
Unable to open log file: SetFileInformationByHandle(): The cloud file provider is not running.
FileListener in error state after initial rotate()
Check the hyperd log for more information
Context: 0x13cead20
Unable to connect to the Tableau Data Extract server "". Check that the server is running and that you have access privileges to the requested database.
Hello Blackronin357! You can get help directly from our instructors at Offsite, our online community - www.offsitebylearnit.com/
Please share this presentation file
They are in the exercise files
UK viewer, the map with states does not load, but the one with countries does. How do I fix it? 22:33
In Menu Bar, go to Map -> Edit and play with settings there. I am from Germany and none of the maps used to load. By changing some settings had it all sorted out.
bro am having that issue i dont see the menu guidness plz@@eminjs2319
Thank you@@eminjs2319 Next you just have to set to United states
@@eminjs2319 Thanks man! I was having the same issue. Your suggestion fixed it!
You need the paid version to open a Microsoft Access file, bummer
You can use the free 14 day trial that Tableau offers - www.tableau.com/products/trial
I think Tableau Public can open MS ACCESS freely
Hi there
, in module 2 Sample-superstore can't be found. could you sahre?
Hello Nong! That data source is included when you download Tableau. You can also download the file here: community.tableau.com/s/question/0D54T00000CWeX8SAL/sample-superstore-sales-excelxls
1:10:00 This file, I can't do like you.
the columns are not separated, they are combined into one column
Hello Bằng Nguyễn Đức! You can get help directly from our instructors at Offsite, our online community - www.offsitebylearnit.com/