Alexis | A 3D painting platform built for WebVR | Augmented Reality library

Piggy-backing on my earlier question here: SUMX, SUMMARIZE, and missing values

I have a new wrinkle that I can't quite work out. I would have thought it was simple or wouldn't even be a problem, but here I am.

Alexis worked out this solution for me that calculates the final amount for each pipeline_event and sums it up for an accurate grand total. What I need to do now is show all that aggregated data split up by the final probability value for that given period of time. The problem is that the same data is showing up in multiple places on the more granular level, even though the grand total is still correct. Let me back up a bit...

We have pipeline_history records and pipeline_event_history records. I've written a SQL query that pulls them into a single row for each matching pair. Each row contains an 'amount' and an 'eveprob'. The latter is a number from the set {0,10,30,50,70,90,100} that reflects the probability that the particular event will close successfully. The values are in a linked table named tblProb[Prob]. Over the course of time, both these values may change, so I may have a result set for a particular event that looks like this:

pipeline_id date_last_mod pipeline_event_id amount eveprob P-03 1/1/2020 PE-04 200 10 P-03 3/1/2020 PE-04 200 30 P-03 5/1/2020 PE-04 200 30 P-03 5/15/2020 PE-04 400 50

What my PivotTable is giving me is this:

Year/Month 0 10 30 50 70 90 100 Total Jan 2020 200 200 Feb 2020 200 200 Mar 2020 200 200 200 Apr 2020 200 200 200 May 2020 200 400 400 400

What I'm after is this:

Year/Month 0 10 30 50 70 90 100 Total Jan 2020 200 200 Feb 2020 200 200 Mar 2020 200 200 Apr 2020 200 200 May 2020 400 400

Here's my measure as it stands now:

...

The problem here are I had a program that accept input like these

...

I have a set of tables that keep the daily information of the registrations. Now I need a query in MySQL that contains total records by current date. I made a query that works fine, but I expected 0 (zero) on the computers that have not registered any records. Here it does not return 0.

I tried IFNULL () and COALESCE () but I still get the same result. Please help with this query. Thanks.......

...

I'm trying to merge two tables in ascending order. So that the id would start from 2. However, the order does not change by sort. The command should be in one line.

...

I've created a random database of 100 soccer players, with randomly generated names, positions, and ability (1-5). I want to append the list so that it reviews the ability of each player and assigns a value (20-100) based on their ability. 1 ability = 20 value. 2=40, 3=60, 4=80, and 5=100. In excel, for example, I would do a vlookup to the ability (1-5) and apply the value based upon the ability number. How would I go about doing this in a Python list? Thanks

...

So I have locally developed Node.js app. I made apache virtual host locally to test the subdomain feature. Let's say the domain is bloggin.fun so every user will had their subdomain. alexis.bloggin.fun etc. How do I use the wildcard subdomain then proxy pass it to desired URL.

My current setup that I also follow from Stack Overflow gave me chrome not found error. Not redirected to the localhost:4040/auth

...

The number of np.where()'s I would assume is the issue since removing 1 will allow the function to work. I'm not aware of another way to edit a name other than an if else. I figured this would be faster. Mapping comes to mind as well, but I'm not sure how to return the names that are not changed. Any help understanding the best practice for this desired outcome would be very much appreciated!

...

(Very new to Python) I have a multi-nested dict in JSON format and I'm trying to check if a specific key value or true or false. I'm unsure of the syntax to check for a key nested within several dicts. I am using the output of URLVoid's API which looks something like this:

...

I'm trying a way that when given a string of names which are first and last names, where names are split by ; and first name split to last name by : ->

...