EternalShima ⚪️

About

Username
EternalShima
Joined
Visits
29
Last Active
Roles
Member
Points
13
Badges
2

Comments

  • Thank you @jaeW_at_Onyx for the solution in beast mode. I am trying to calculate the rolling average at the country level (about 200 countries) For the average, I used the following code in beast mode : ( lag(COUNT(`SEG_Mktg` in 'Yes'),1) over(PARTITION by `Country` order by MONTH(`Snap`))+ lag(COUNT(`SEG_Mktg` in…
  • Hello, I want to do kind of the same operation but more for Type 0 to Type 70 for example. In the Table card, I want to see first ordered by Country and then Month. What Should I do? (I tried two-time order but gave me a syntax error) Now my table uses the following code in beast mode COUNT(`Mktg` in 'Yes'),1)…