Assigned
Status Update
No update yet.
Comments
vi...@google.com
rn...@gmail.com
is there any news on this?
vi...@google.com Restricted
Restricted
Comment has been deleted.
vi...@google.com
I had to implement a solution to pivot 300 rows into columns. We need a better way to pivot rows. Conditional aggregation or sql generators are cumbersome and error-prone.
sp...@gmail.com
Even Kurt's example linked above still requires you to write out 300 clauses for each column. Generating SQL really is the best option.
pa...@gmail.com
We want something like:
SELECT * FROM
(
SELECT
category_name,
product_id
FROM
production.products p
INNER JOIN production.categories c
ON c.category_id = p.category_id
) t
PIVOT(
COUNT(product_id)
FOR category_name IN (
[Children Bicycles],
[Comfort Bicycles],
[Cruisers Bicycles],
[Cyclocross Bicycles],
[Electric Bikes],
[Mountain Bikes],
[Road Bikes])
) AS pivot_table;
SELECT * FROM
(
SELECT
category_name,
product_id
FROM
production.products p
INNER JOIN production.categories c
ON c.category_id = p.category_id
) t
PIVOT(
COUNT(product_id)
FOR category_name IN (
[Children Bicycles],
[Comfort Bicycles],
[Cruisers Bicycles],
[Cyclocross Bicycles],
[Electric Bikes],
[Mountain Bikes],
[Road Bikes])
) AS pivot_table;
pa...@google.com
Any update regarding PIVOT functionality?
tu...@google.com
an...@gmail.com
update!
ja...@gmail.com
not sure where to upvote so writing here instead. i would love this!
ro...@googlemail.com
Yes please!
ly...@gmail.com
Yes, great idea!
an...@gmail.com
Would be very helpful indeed.
ri...@googlemail.com
Yes, great idea!
ro...@googlemail.com
Would like to use that too
er...@gmail.com
+1
je...@gmail.com
+1
is...@google.com
ma...@google.com
ze...@gmail.com
+1
pr...@googlemail.com
+1
Description
The proximity sensor doesn't work on dark surfaces, preventing the Always-on display to turn off when the phone is face down on a table, or when in a pocket lined with dark fabric. It also makes Flip to Shh unreliable as it doesn't engage sometimes when the phone is on a dark surface.
I recorded video in comparison with a Pixel 3 for more clarity, high pitch beep is proximity on and lower pitch proximity off:
This was done with a Tasker task for testing.