rmbourne Member

Comments

  • Hi @GrantSmith Thanks. I tried but it doesn't work either. The use of partition was actually my initial approach, but I used MAX(MAX() FIXED (BY)) following the documentation on FIXED function. Neither of them worked. It turns out, even the partition can't be within an aggregation as it works if I removed the COUNT()
    in Beast mode referencing Comment by rmbourne May 21
  • @david_cunningham it works, this is clever. Thanks for your help.
    in concat() integers Comment by rmbourne May 6
  • Oh, I overlooked that one. Thanks for pointing that out. I thought there was something that I didn't understand in that function. Thanks @MichelleH
    in PERIOD_DIFF Comment by rmbourne March 20
  • Hey @ArborRose, Yeah I've tried it before, but I intend this to reference the month filters, that's why I didn't do it in the ETL this time and I'm searching for ways to be able to do it in the beast mode.
    in Beastmode listagg/group concat Comment by rmbourne February 14
  • Wow! I can't believe it's that simple. Thank you @MichelleH and @marcel_luthi, it works just the same. Plus, if ever we reach more than 700 accounts in the future, there's no need to add more lines in the formula. Thanks!
    in Array Function in Beast Mode Comment by rmbourne February 7
  • Hey @AnnaYardley, any chance I can still try this out?
    in App Studio Alpha Opportunity Comment by rmbourne January 10
  • @MarkSnodgrass, thanks for responding. However, that's not what I'm going for. What I wanted instead is to just count everything within the partition for every row. If this is SQL, I would've simply written it as COUNT(invoice_item_model) OVER (PARTITION BY end_user_domain) The problem is in Magic ETL, it seems the frame…
    in Rank and Window: Unbounded following Comment by rmbourne November 2023
  • Hi @DataMaven, Thank you for looking into this. I've done the same thing and I didn't come up with anything that would result to a slope of -1.3. I better file a support ticket for this now. Thank you.
    in Regression Line - Hover/Label Text Comment by rmbourne July 2023
  • @GrantSmith I just figured it out. The option to add a variable into a page is accessible when the dashboard is being edited. I'm such a newbie. Thanks man!
    in Filter Chart Type Comment by rmbourne June 2023
  • Thank you for your help @GrantSmith. I've used the variable in a beast mode to make my x-axis dynamic. I'm aware that the option to choose to make the control appear in the analyzer and in the controls pane of an individual card is available, but not on a dashboard page. Can you walk me though how I can add the variable…
    in Filter Chart Type Comment by rmbourne June 2023
Default Avatar