pivot | Supplementary source code for A Spherical Cap

People of Stack Overflow!

Thanks for taking the time to read this question. What I am trying to accomplish is to pivot some data all from just one table. The original table has multiple datetime entries of specific events (e.g. when the customer was added add_time and when the customer was lost lost_time). This is one part of two rows of the deals table:

I want to create a view of this table. A view that has one row for each distinct date and counts the number of events at this specific time.

This is the goal (times do not match with the example!):

I have working code, like this:

I have seen tons of answers but could not get it right. Basically I want to show duplciate on separate row while performing pivot wider.I created a unique variable as well but the result was either nested row or separate row for each column.

Following script is a combination of RSI and Higher High and Lower Low script. The issue is that the HH LL labels are aligned for the price not on the RSI Line. How to align the labels to the RSI line? It is basically showing the Higher Highs and Lower Lows of RSI. The labels need to stick on to the respective RSI line.

I've been playing around with Eloquent for a while, but I met a case where Eloquent::where() is not working as I expected. I managed to get Collection::where() worked instead though. However, I'm still wondering why Eloquent::where() didn't work in my case. I will keep the problem as simple as I can, here it goes:

• I have Product and ProductCategory as many-to-many relationships and the pivot table name is "product_relate_category".
• Here is the relationship between them. It's still working so you can skip

I wanted a ArrayFormula at C1 which gives the required result as shown.

Entry sheet:
(Column C is my required column)

Date Entered is the date when the Name is Assigned a group i.e. a, b, c, d, e, f

Criteria:

1. The value of count is purely on basis of Date Entered (if john is assigned a on lowest date(10-Jun) then count value is 1, if rose is assigned a on 2nd lowest date(17-Jun) then count value is 2).
2. The value of count does not change even when the data is sorted in any manner because Date Entered column values is always permanent & does not change.
3. New entry date could be any date not necessarily highest date (If a new entry with name Rydu is assigned a on 9-Jun then the it's count value will become 1, then john's (10-Jun) will become 2 and so on)

Example:

After I sort the data in any random order say like this:

Random ordered sheet:
(Count value remains permanent)

And when I do New entries in between (Row 4th & 14th) and after last row (Row 17th):

Random Ordered sheet:
(Doesn't matter where I do)

1. ={"AF Formula1"; ArrayFormula(IF(B2:B="", "", COUNTIFS(B$2:B, "="&B2:B, D$2:D, <"&D2:D)+1))}
2. ={"AF Formula2";INDEX(IFERROR(1/(1/COUNTIFS(B2:B, B2:B, ROW(B2:B), "<="&ROW(B2:B)))))}

I tried to figure my own ArrayFormula but it's not working:

I got Formula for each cell:
=RANK($D2,FILTER($D$2:$D, $B$2:$B=$B2),1)
I figured out Filter doesn't work with ArrayFormula so I had to take a different approach.

I took help from my previous question answer (Arrayformula at H3) which was similar since in both cases each cell FILTER formula returns more than 1 value. (It was actually answered by player0)

Using the same technique I came up with this Formula which works absolutely fine :

=RANK($D2, ARRAYFORMULA(TRANSPOSE(SPLIT(VLOOKUP($B2, SUBSTITUTE(TRIM(SPLIT(FLATTEN(QUERY(QUERY({$B:$B&"×", $D:$D}, "SELECT MAX(Col2) WHERE Col2 IS NOT NULL GROUP BY Col2 PIVOT Col1", 1),, 9^9)), "×")), " ", ","), 2, 0), ","))), 1)

Now when I tried converting it to ArrayFormula: ($D2 to $D2:$D & $B2 to $B2:$B)

=ARRAYFORMULA(RANK($D2:$D,TRANSPOSE(SPLIT(VLOOKUP($B2:$B, SUBSTITUTE(TRIM(SPLIT(FLATTEN(QUERY(QUERY({$B:$B&"×", $D:$D}, "SELECT MAX(Col2) WHERE Col2 IS NOT NULL GROUP BY Col2 PIVOT Col1", 1),, 9^9)), "×")), " ", ","), 2, 0), ",")), 1))

It gives me an error "Did not find value '' in VLOOKUP evaluation", I figured out that the problem is only in VLOOKUP when I change $B2 to $B2:$B.

I'm sure VLOOKUP works with ArrayFormula, I fail to understand where my formula is going wrong! Please help me correct my ArrayFormula.

Here is the editable sheet link

I'm building a web app using Laravel 8 and one thing I tend to struggle with is the complex relationships and accessing the data. I've started reading on hasManyThrough relationships but I'm not convinced that's the correct way to do it for my scenario.

The app is used by travelling salesmen to check in to a location when they arrive safely.

I have three main tables:

• Locations (where they are visiting),
• Checkins (where their check in data is stored, e.g. time),
• Users

This is where it gets a little complex and where I find myself not being able to see the wood for the trees...

• Locations have many users, users have many locations. Many-to-many pivot table created.
• Locations have many check ins, check ins have many locations. Many-to-many pivot table created.
• Check ins have many users, users have many check ins. Many-to-many pivot table created.

As such they're all created using a belongsToMany relationship.

Now what I'd like to do is access the user of the check in so I can call something similar to on my show.blade.php:

I am very new to Python. I have a dummy dataset (25 X 6) for practice. Out of 6 columns, I have 1 target variable (binary) and 5 independent variables (4 categorical and 1 numeric). I am trying to view my target distribution by the values within each of the 4 categorical columns (and without writing code for separate columns - but with a for loop usage so that I can scale it up for bigger datasets in the future). Something like below:

I am already successful in doing that (image above), but since I could only think of achieving this by using counters inside a for loop, I don't think this is Python elegant, and pretty sure there could be a better way of doing it (something like CarWash.groupby([i,'ReversedPayment']).size().reset_index().pivot(index = i,columns = 'ReversedPayment',values=0).axes.plot(kind='bar', stacked=True). I am struggling in handling this ax = setting) Below is my non-elegant Python code (not scalable):

I am trying to create many-to-many relation with a file attachment pivot in OcotberCMS.

Here's my relation

I have following result set,

Now with above results i want to print the records via select query as below attached image

Please note, I will have only two types of columns in output Present Employee & Absent Employees.

I tried using pivot tables, temporary table but cant achieve what I want.