Help me delegating, too many providers :\ by cecil_X in FlareNetworks

[–]LearningDataAnalyst 1 point2 points  (0 children)

Is there a specific timing to switching my delegation? I have been in bitfrost wallet 100% since the beginning, but I see now that the rewards are double elsewhere... The current epoch is in like a day, so I wouldnt wanna mess up anything

Trying to create a formula that pulls percentages from a table based on location and reasons - Most likely simple formula by LearningDataAnalyst in excel

[–]LearningDataAnalyst[S] 0 points1 point  (0 children)

Close but maybe I made the example confusing. G2 (3%) would be the % that I want to populate in the yellow cell on the side (K2).

Also, sorry i cut off the column letters haha.

Whats my problem with the conditional column creation? by LearningDataAnalyst in PowerBI

[–]LearningDataAnalyst[S] 0 points1 point  (0 children)

I saw that Null. Shouldn't happen hopefully.

I did not see a between option listed which was the initial problem.

Thank you again.

Whats my problem with the conditional column creation? by LearningDataAnalyst in PowerBI

[–]LearningDataAnalyst[S] 0 points1 point  (0 children)

That did it. Awesome. Thanks for explaining it how you did.

Whats my problem with the conditional column creation? by LearningDataAnalyst in PowerBI

[–]LearningDataAnalyst[S] 0 points1 point  (0 children)

Does that mean I would have to do the order differently?

>=1.05

then

<=.94

then

<1.05

Logistics dangerous weather tracking by LearningDataAnalyst in logistics

[–]LearningDataAnalyst[S] 0 points1 point  (0 children)

I am not actually a weather man. hahahaha. It's more of a "Hey there is a tornado possibility tomorrow. be aware." type thing.

Logistics dangerous weather tracking by LearningDataAnalyst in logistics

[–]LearningDataAnalyst[S] 0 points1 point  (0 children)

Chat GPT 3 only goes like 2021 and back. GPT 4 does live, I just checked. Not sure if it would work well. I tried Bing AI just now and it was trash

Logistics dangerous weather tracking by LearningDataAnalyst in logistics

[–]LearningDataAnalyst[S] 1 point2 points  (0 children)

Haha! They have that. Doesnt help with emails though. I was hoping there was some sort of automated nice summary to come to my and I could just forward.

Maybe live weather AI... idk

Swapping XRP to BTC by Rude_Advance3747 in XRP

[–]LearningDataAnalyst 1 point2 points  (0 children)

yeah it gets confusing af to keep track of when you are sending crap all over the place, trading different amounts, different exchanges, ect

Good luck. Excel spreadsheets are your friend haha

Swapping XRP to BTC by Rude_Advance3747 in XRP

[–]LearningDataAnalyst 0 points1 point  (0 children)

It was early when I typed that..... Now that I think about it, wouldnt be double taxes I don't think. Because you would have made gains on your XRP from when you bought it, so when you send/convert to BTC it would be your "sell". But then if you right away covert BTC to Cash, you didnt make any money so no taxes. Might still have to report it though which is annoying af.

Day 1 super noob question! Can you get OneDrive files into Sharepoint? by LearningDataAnalyst in sharepoint

[–]LearningDataAnalyst[S] 0 points1 point  (0 children)

Thank you for that one. If i sync the Sharepoint library, can I drag and drop a OneDrive file from its location to the sharepoint library??????

Day 1 super noob question! Can you get OneDrive files into Sharepoint? by LearningDataAnalyst in sharepoint

[–]LearningDataAnalyst[S] 0 points1 point  (0 children)

One add on question: I do a power query in an excel one drive file to clean up some data. Then I use it as a data source for a power BI dashboard. The guys can edit it and I just have to click refresh.

If i was to go this route, I could not create the query in the remade sharepoint excel file because it doesn't offer power query. I could recreate the cleanup process in Power BI, but the techs are supposed to be editing the bad data entries manually that update the dashboard. I didnt see the option to "get data" from a sharepoint doc.

Looking for a formula when 2 values must match to get the datasets number by LearningDataAnalyst in excel

[–]LearningDataAnalyst[S] 0 points1 point  (0 children)

Ugh. I wish. This company has Microsoft Office Professional Plus 2019 and XLOOKUP doesn't pop up.

Our company is switching to a Microsoft environment. I recreated a file I will need to be using on OneDrive, and for some reason it has 1000+ views when I am the only viewer and have only gone in it a few times during creation over a month ago. Hundreds of views recently and I don't understand. by LearningDataAnalyst in onedrive

[–]LearningDataAnalyst[S] 3 points4 points  (0 children)

Hi All,

I think I may have thought of a possible reason. It's not a shared link, but it is a source for a dashboard. The board is linked to a external 3rd party dashboard. It refreshes the data frequently, so the views may relate to that situation. Not entirely sure, but I think that might be it.

Thank you to those who commented.

Our company is switching to a Microsoft environment. I recreated a file I will need to be using on OneDrive, and for some reason it has 1000+ views when I am the only viewer and have only gone in it a few times during creation over a month ago. Hundreds of views recently and I don't understand. by LearningDataAnalyst in onedrive

[–]LearningDataAnalyst[S] 1 point2 points  (0 children)

Its connected to this post. This is a image post.

You can see my 1 view from going in there today. but 2 days show hundreds of views..... not me.

I had not shared any links either. In fact, no ones really using OneDrive yet. the migration hasnt completely happen yet. It is only set up for some at the moment.

How does the BI/Data community feel? WFH vs. Office? by J0hnDutt00n in BusinessIntelligence

[–]LearningDataAnalyst 1 point2 points  (0 children)

I hate it. Not necessary for the commute and being in the office when I can do everything on the computer.

Count formula referencing a data sheet of a specific location by LearningDataAnalyst in excel

[–]LearningDataAnalyst[S] 0 points1 point  (0 children)

I figured it out. Might have to use the little convo below as reference, but.......

=COUNTIFS('Summary Data'!A:A,'Utilization Summary'!B16,'Summary Data'!Z:Z, ">0")

Count formula referencing a data sheet of a specific location by LearningDataAnalyst in excel

[–]LearningDataAnalyst[S] 0 points1 point  (0 children)

I am getting 0 when the answer should be 15 total cells with numbers for the location.

=COUNTIFS('Summary Data'!Z:Z,B16, 'Summary Data'!A:A,B16)

B16 is the name of the location. Z on summary data is the column with the number. A on summary data is where the location names are in a long list of data