my calculated fields are not showing in measure values but instead under measure names. Help to fix it
@maxchergik243911 күн бұрын
You know you can insert automatically into MySQL all data straight from python, right?
@jakobpirs13927 күн бұрын
how?
@indianfacts193618 күн бұрын
thanks of lot ...i have no words for you but such as you are a great man...this error have taken my a lot of time but after seen your video my all problem was solved as clear cut to cut ...once again thanks of lot...🙌🙌❤❤
@sandeepanand383425 күн бұрын
how to insert dataframe directly into mysql without manual pasting?
@gaurabparajuli364325 күн бұрын
wow
@DerLuchtАй бұрын
You have no idea how grateful I am. I've tried everything, and nothing worked, and OMG this was a great solution! A tip for ppl with the same problem: ProgramData may be a hidden folder, so you may have to change the properties settings to see it. And also, instead of changing the file, you can just copy your table data file into the Uploads folder, and it will all be the same :)
@mayadisilalahixipmia-1657Ай бұрын
but how to limit the number of rows i'm want to import? (in this case, i jusr want to import the first 1000 lines)
@ramu000009Ай бұрын
But the chart is not showing the 9.51% as the text!!!!!
@Emotion-od8obАй бұрын
U got new subscriber 🎉
@Emotion-od8obАй бұрын
Omg thank you so much have seen many vedios but nothing workes. U just saved me thank you thank
@A-museDesign2 ай бұрын
Is there anyway to do this with less than 12 months of data? I can not do this and I think it might be because my data set has dates that don't total a full year.
@EuTomcosta2 ай бұрын
👏👏👏👏
@MissP32243 ай бұрын
But Excel can't load the huge file to clean it there🥲
@jurgenklismannbolivarromer90513 ай бұрын
It appear this (20:56:49 load data infile 'freight.csv' into table freight fields terminated by',' ignore 1 lines Error Code: 1292. Incorrect date value: '2018-01-02;10975;38;774571;MMA-5946;Herrings Crossroads;7' for column 'fecha' at row 1 0.000 sec )
@bhavya.763 ай бұрын
I am getting an Error Code: 1290. The MySQL server is running with the --secure-file-priv option so it cannot execute this statement. pls help
@indykoncepts28783 ай бұрын
Thank you for this. This is helpful. However, I have been having error 1050. Table hotel_bookings already exists
@huguititi4 ай бұрын
Thanks!!! the form of the videos and the step by step are really nice!!!
@frederickjabagat67654 ай бұрын
Error Code: 1292. Incorrect date value: '2020' for column 'date_added' at row 1 I still keep getting this error even thought I updated my data dates from yyyy-mm-dd
@tholetivamsidharreddy62614 ай бұрын
Help me out where the txt file will be saved
@tholetivamsidharreddy62614 ай бұрын
Where the file will be stored
@tholetivamsidharreddy62614 ай бұрын
Where the file will be saved
@mohdhammad2414 ай бұрын
Assalamu alaikum, Mashallah youssef brother love from India, please make more dashboard like this❤❤❤
@rinchendorji944 ай бұрын
Is program file same as program data?
@shubhangibajpai87165 ай бұрын
The changes can't be saved as it is saying that we you dont have permission for that please help to solve my problem
@ErwanKow-er2kf4 ай бұрын
Right click the file and go to the file's "Properties", then Security and chek "Full control"
@mouryaadey58635 ай бұрын
I can't find that file MY
@ND-lf3rg5 ай бұрын
HELLO i HAVE TRIED YOUR STEP BUT THEY ARE GIVING ME THIS ERROR: Error Code: 1290. The MySQL server is running with the --secure-file-priv option so it cannot execute this statement
@pravashpinku81065 ай бұрын
nicee
@markjustinsayson75955 ай бұрын
how can I edit tha datas within the table?
@JohnTittel6 ай бұрын
I am surprised that Tableau does not offer this slicer option. Your video is excellent though.
Tableau is pretty great but this is ridiculous lol
@asuquobassey12026 ай бұрын
Still having issues. My dataset does has lot of null values and its not a calculated field you can easily apply formula. How do I import this file with the nulls
@opal-r2h6 ай бұрын
That's crazy. In powerBI, you just add a filter button OMG.
@sunidhibhat13426 ай бұрын
But it is showing error saying server is running with secure server file priv option. What shld i do
@AnalyticsExplorers6 ай бұрын
Hi there, Go watch this short video and I hope it will help kzbin.infon4xjOUnfOMY?si=qr6LFLij2jNRsBh2 Good luck!
@Sprinkle-ru3eb7 ай бұрын
Hey I am getting error while importing " the MySQL server is running with the -secure-file-priv option so it cannot execute this statement
@Sprinkle-ru3eb7 ай бұрын
Help me
@AnalyticsExplorers7 ай бұрын
@@Sprinkle-ru3eb Hello, You can find your problem solution in this short video kzbin.infon4xjOUnfOMY?si=3jVUpEcwlGMheR-w Best of luck!
@sanikasunil54407 ай бұрын
bro i want to import csv file containing 60000 rows into wix but there is a limit of 50,000 rows so i am trying to upload it to mysql(external database option) how do i achieve this?
@shaikasma60147 ай бұрын
its showing u dont have permission to open this file
@sergiotorres5137 ай бұрын
Buddy, thank u so much for this video. I got a problem trying to resolve the secure-fiele-priv issue, but I read your comments and I could resolve it. THANKS A LOT.
@AnalyticsExplorers7 ай бұрын
Grateful that my video helped you!🙏
@Magistrado19147 ай бұрын
Excellent.
@AnalyticsExplorers7 ай бұрын
Thank you for your feedback🙏
@dezinhtang7 ай бұрын
as a data analyst,it’s possible that just import all excel data to mysql and query data as we need without learning excel ?
@ashutoshkumartiwari32097 ай бұрын
Is it possible to import data from excel to MYSQL on regularly ?
@jiancarlochua53467 ай бұрын
not all the dashboard is sales basis what if for asset management? that is why that profit margin does not apply always, please make an example that is generic to all
@artmisbabaei56598 ай бұрын
I have a question. I have a bar chart, showing the percentage of A from B. I want the bar to be green if it meets the target (constant), and red if not. Now, I've created the color calculated field, saying if percentage was higher than target then 1, else 0. But when I'm adding the field to color, it only shows 1 or 0. Not both so that I be able to set the colors. I do not know what is the problem. I did add other fields, thought maybe it's because it's a one bar, but again, I do not get both values, only then one which applies to the condition. Appreciate your help in this regard.
@AnalyticsExplorers8 ай бұрын
Hi there, Hope you're doing well. This approach is not suitable for your case as tableau shows only the available values only for the field you created. So, if your calculated field has all values of 1 then tableau will show 1 in the color field unlike this video where we have both values (0,1) in the fields values.
@artmisbabaei56598 ай бұрын
@@AnalyticsExplorers Hello, thank you for taking the time. May I ask if you have any suggestions for what I need to do?
@louisocarroll8 ай бұрын
What if mysql server is not on local computer? I keep getting the error: "Access denied for user..."
@ManjeetKaurSardar8 ай бұрын
Good one, but this is possible only when all dashboards are in same file, what if all dashboards are in different locations and files, what tool needs to be used??
@johnvak73908 ай бұрын
Why am i getting "OS errno 2 no such file found"? I deleted the secur-priv and saved csv in the correct schema i want it to upload. ahhhhhhhhhhhh
@AnalyticsExplorers8 ай бұрын
Did you put your csv file in the correct directory?
@johnvak73908 ай бұрын
I think so. Program data - Mysql - mysql server 8.0 - data -tablename - table@@AnalyticsExplorers
@johnvak73903 ай бұрын
@@AnalyticsExplorers I forgot what I did; it's been a while, but it's fixed. Thanks for creating this video as my company has transitioned from ms access to an actualy rdbms
@suvarna6258 ай бұрын
Everything went well until the last step. While trying to execute load data I file step, getting error code 1290. Can anyone please help me with it.
@AnalyticsExplorers8 ай бұрын
Hello Suvarna, You can find the solution in our short video here: kzbin.infon4xjOUnfOMY?si=rj1MxuCMHAI9lpQ5 Good luck and if you find it useful, don't forget to spread it with your colleagues!😀
@AnalyticsExplorers9 ай бұрын
Explore more Tableau Tips here: kzbin.info/aero/PLkKXgGjnuuRYPqA7gsmyzOjlMy-S6BZfC&si=4a5SXeCDpGYASK-S
@AnalyticsExplorers9 ай бұрын
Explore more Tableau Tips here: kzbin.info/aero/PLkKXgGjnuuRYPqA7gsmyzOjlMy-S6BZfC&si=4a5SXeCDpGYASK-S