Cumulative sum wich multiples conditions

Hello,

I have a soccer’project with multiple league .

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

2a72bdf7-b3c1-4e26-af4a-d02e366b364c.png
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 ….
    

0 0 530
0 REPLIES 0
Top Labels in this Space
Top Solution Authors