EternalShima Member

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…
    in How can I group multiple columns by year-month in the dataflow? Comment by EternalShima January 2022
  • 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)…
    in How to calculate the total sum of a field in beast Mode Comment by EternalShima January 2022
Avatar