python (65.1k questions)
javascript (44.2k questions)
reactjs (22.7k questions)
java (20.8k questions)
c# (17.4k questions)
html (16.3k questions)
r (13.7k questions)
android (12.9k questions)
Checking values for a dict of objects in python
I have a list of dicts e.g. [{'X':0,'Y':0},{'X':1,'Y':2}] and I want to check to see if every X and Y value is equal to 0. I have tried some methods such as the all() function and the .values() functi...
Jack Timber
Votes: 0
Answers: 1
Sum values based on distinct values in another column plus another criteria
I am trying to find the value of the Sale $ based on the unique Deal #s by location. I can get a total value for unique Deal #s using
=SUMPRODUCT(C11:C23/COUNTIF(B11:B23,B11:B23))
but I can't figur...
Marissa
Votes: 0
Answers: 1
How to get rolling unique count of employees per year based on key fields
I have the following table and I wanted to get the running unique count by dept, team, level. But the cumulative unique count will restart per year.
Note: sorry in my main table example, employee numb...
pattieto
Votes: 0
Answers: 1
In MongoDB, can we get distinct values of a field regardless of hierarchy?
I am creating an application to store and display multiple hierarchies. I am storing json data in nested tree format like the following
{
"text":"Node1",
"children":
...
Udhayha Karthik
Votes: 0
Answers: 0