0

enter image description here

on that picture, that is user_id and the right side are the frequency of transaction for each users,

how to display the minimum, max, median, and average for the frequency transaction of this users?

what calculation do i need to made for this kind of problems?

so the median max min and average will appear

18Man
  • 572
  • 5
  • 17

1 Answers1

1

Check this article about Window Functions

For the min use WINDOW_MIN(COUNTD([Order Id]))

For the max use WINDOW_MAX, etc

Andy TAR Sols
  • 1,725
  • 2
  • 5
  • 12