Question

Cumulative sum wich multiples conditions

  • 15 July 2022
  • 0 replies
  • 480 views

Hello,

I have a soccer’project with multiple league .

I want to create measure to sum the points by team by stage by league …

Table

I know who do this withbigquery with windows function etc … but i try to use running_total to create measure in the explore but without success

measure: cumulative_points {
    type: running_total
    sql: ${points} ;;
    }

 

But i don’t konw where to specifies i want the sum by team,by stage and by season ….
    

 


This topic has been closed for comments