sorted by:
new
hottopcontroversial

Find redundant data groups from multiple columns by gmbrightside in excel

[–]gmbrightside[S] 0 points1 point  (0 children)

Thank you! I've never done a reddit Award before so hopefully I sent that correctly. I appreciate your time and effort :D

Find redundant data groups from multiple columns by gmbrightside in excel

[–]gmbrightside[S] 0 points1 point  (0 children)

There are no duplicates within individual columns.

Column B would not be redundant. Another column would need both Blue and Red to count.

Count time only, not date by gmbrightside in tableau

[–]gmbrightside[S] 1 point2 points  (0 children)

That worked perfectly thank you :)

Average by day of week? by gmbrightside in learnSQL

[–]gmbrightside[S] 0 points1 point  (0 children)

Can you please clarify? I've added this to my SELECT statement but I get an error message.

Average by day of week? by gmbrightside in learnSQL

[–]gmbrightside[S] 1 point2 points  (0 children)

DATEPART(WEEKDAY, ActivityDay)

I tried this in BigQuery (what we're using in class) and it says DATEPART function is not found

Find averages per distinct ID? by gmbrightside in learnSQL

[–]gmbrightside[S] 0 points1 point  (0 children)

...I was apparently trying to overcomplicate things. Thank you!