referral | ️‍️ Find , filter , and sort your Ruby code | Code Analyzer library

I want to create a Django application referral system for profiles created by user upon login

whenever a people login they get a option to create a profile and in that create profile form their is input for referral code which eventually add some point to referred by person

here is my Profile Model

I need to do the case when on the nested table. The table is looked like this:

I want to take each customerId and the counts of their completed referral. The completed referral rules is, when isActive Yes, balanceFullfilment Yes, and disbursmentStatus Yes.

The output may look like this:

I'm working on a query but it's returning some duplicate values and I need to return only the row where the date in one column is closest to the date in another column.

My query looks something like this:

Using help from this answer: Grouped stacked bar graph: issues regarding order of stack, horizontal orientation of graph and label of groups

I have strings in a column that contain persons' middle initials and last names that I need to extract. The name always appears after "Referral to " text. However, the text can end with the last name or it can have a second part that begins with " (". For example,

Option 1: "Referral to J. Smith"

Option 2: "Referral to S. James (1st priority)"

There can be variations of text before and after, e.g.

Option 1a: "Urgent Referral to J. Smith"

Option 2a: "Referral to S. James (TBD)"

The text I needed extracted is always located after "Referral to " and sometimes also before " ("

Thank you for any help.

I have using the Nebular ngx-admin template in my angular application. Also using ng2-tel-input for mobile number input. I am having the below HTML code

I am working on a charting module where I can pass on dataframe and the module will create reports based on plots generated by calling few functions as mentioned below.

I am using Altair for plotting and "Datapane" for creating the report, the documentation of the same can be found here : https://datapane.github.io/datapane/

My DataFrame looks like this

I have a database of users (represented by visitorId) who belong to a specific channel and exhibited certain behaviors, as logged under the eCommerceActionType field.

I want to output a table that keeps a tally of users who both "added_to_cart" and "purchased" by channel. So the result should look like:

What is the most efficient query to produce this table?

Appreciate any help I can get.

For the code below I am trying to create a barplot. If the column name in column ACQUISITION_CHANNEL = 'Referral' then the bar should be red else grey.