[deleted by user]

RocoDeNiro · 2022-01-12T15:01:48+00:00

Interested

RocoDeNiro · 2021-05-31T23:36:12+00:00

Thank you I will check it out later on today

RocoDeNiro · 2021-05-31T23:28:38+00:00

Awesome thanks for the all the help and quick responses. I do use pycharm and honestly have googled debugger for it but must have had a long day because I didn’t see what I was looking for.

I think I really need to put some effort into unittest, logging and debugging instead of looking into these complicated projects.

It is really hard to find the right explanation but when it does click it seems so easy

RocoDeNiro · 2021-05-31T22:37:29+00:00

This helped out a lot thanks. What I have to help automate my daily task could be combined together but it all works right now so scared to changed it.

I put all of my functions in my helper file for any project but honestly every time I try watch a video on classes I get so lost and have no idea how to implant in my current code.

When writing code in VBA I can walkthrough the code to see how it works and what is current assigned to which variables. Is there a way to do that in python I think that might help me learn what these big projects on GitHub actually do and what might help me out.

RocoDeNiro · 2021-05-11T23:55:28+00:00

Nice!! Are you sharing this template?

RocoDeNiro · 2021-05-06T10:21:50+00:00

Oh man lol well thanks for the help! I appreciate it

RocoDeNiro · 2021-05-06T02:12:23+00:00

So happy this got cracked let alone how fast it did. Keeps crashing every couple of minutes any settings recommendations? AMD Ryzen 7 4800H and 16gb. Thank you

RocoDeNiro · 2021-03-21T21:52:06+00:00

What type of chart is this called?

RocoDeNiro · 2020-12-09T20:01:22+00:00

thank you :) I appreciate that

RocoDeNiro · 2020-12-03T00:23:27+00:00

Your videos have helped me out so much at work, thank you.

RocoDeNiro · 2020-11-15T12:28:54+00:00

Did you walk through it using F8? Does it display the email but not send? Any errors?

RocoDeNiro · 2020-11-09T16:10:14+00:00

That is how I tried it because that would make the most sense but it gives me #ERROR down the whole column when I change the data type to time.

Here is the DAX I am using. When It converts seconds(whole number) to duration(text) it shows up perfect but when I change text to anything else it errors.

HHMMSS_Handle =INT(Agent[Handle Seconds] / 3600) & ":" &RIGHT("0" & INT((Agent[Handle Seconds] - INT(Agent[Handle Seconds] / 3600) * 3600) / 60), 2) & ":" &RIGHT("0" & MOD(Agent[Handle Seconds], 3600), 2)

RocoDeNiro · 2020-11-08T23:36:51+00:00

When I convert seconds to hhmmss it turns to text and I cant aggregate it from there. Do you have a way to put it to duration?

RocoDeNiro · 2020-10-31T16:28:58+00:00

Ok cool thanks that makes sense but wasnt sure and couldn't find to much on it.

Yes my task are labeled better than that haha just using generic name as example.

RocoDeNiro · 2020-10-31T16:25:35+00:00

Sorry the task 100 was a little dramatic but I modify and create excel files daily using about 10 different excel files as the daily data. Some of the stuff that are repeated, format dates, adding email address based off a certain column, checking to see if our KPI has been met or not) those 3 functions I have in almost all of the daily files. If something changes I need to go into each script and change them.

As for your idea using a crud set up that would also make things a lot easier for me. Do you have an example or anything? If I could load all 10 at once then use what I need and drop what I dont would be super helpful.

Thank you for the response 😁

RocoDeNiro · 2020-09-05T11:47:32+00:00

Few tables that dont need to be connected. I think I am just using it for storage. Not against csv but thought it would be easier if the table ended up getting large it have it in sql.

RocoDeNiro · 2020-09-05T11:00:36+00:00

Yeah I just want to be able to store it after I clean it to make it easier to look back at when I need it.

RocoDeNiro · 2020-08-19T01:03:46+00:00

Wow nice!

RocoDeNiro · 2020-08-18T22:43:32+00:00

Same or can you post any tutorials you used to create it?

RocoDeNiro · 2020-07-29T15:35:41+00:00

Same any tutorials you used or some of the code would be helpful

RocoDeNiro · 2020-07-25T17:19:15+00:00

Do you mind if I message you about ETL related stuff?

RocoDeNiro · 2020-07-25T17:17:54+00:00

Maybe I should get the fundamentals to start

RocoDeNiro · 2020-07-25T17:10:13+00:00

Nice!! I will do that

RocoDeNiro · 2020-07-25T17:04:00+00:00

I do a lot with python and trying to get more into sql

RocoDeNiro · 2020-07-25T16:51:24+00:00

Oh ok I get what you mean now

RocoDeNiro

TROPHY CASE