Skip to content

    • Beast Mode

    Beast Mode

    I am using this beast mode but it wont let me save the card

    Member
    in Beast Mode

    count(ID) over(partition by Clinic,Product)

    Tagged:

    Welcome!

    It looks like you're new here. Members get access to exclusive content, events, rewards, and more. Sign in or register to get started.
    Sign In

    Best Answers

    • Coach
      Answer ✓

      Ok, there's likely some other setting that's causing issues. Do you have any beast modes still on the card which reference a field that no longer exists? Are there empty color settings?

      If you right click on the page and select Inspect from the menu it will bring up the developer console, if you select the network tab and then click save are there any entries in the network tab that are red? You can possibly explore that to see if there's a better error message for you to reference.

      **Was this post helpful? Click Agree or Like below**
      **Did this solve your problem? Accept it as a solution!**
    • Coach
      Answer ✓

      @domoexpert Try adding another open parenthesis before "partition":

      1. COUNT(MAX(`ID`)) OVER (PARTITION BY `Clinic`, `Product`)

    Answers

    • Coach
      edited May 2023

      You need to aggregate the aggregate when using a window function in a beast mode because of how Domo processes the beast mode.

      You could do something like:

      1. COUNT(MAX(`ID`)) OVER (PARTITION BY `Clinic`, `Product`)
      **Was this post helpful? Click Agree or Like below**
      **Did this solve your problem? Accept it as a solution!**
    • Member

      Still not letting me save the card

    • Coach
      Answer ✓

      Ok, there's likely some other setting that's causing issues. Do you have any beast modes still on the card which reference a field that no longer exists? Are there empty color settings?

      If you right click on the page and select Inspect from the menu it will bring up the developer console, if you select the network tab and then click save are there any entries in the network tab that are red? You can possibly explore that to see if there's a better error message for you to reference.

      **Was this post helpful? Click Agree or Like below**
      **Did this solve your problem? Accept it as a solution!**
    • Coach
      Answer ✓

      @domoexpert Try adding another open parenthesis before "partition":

      1. COUNT(MAX(`ID`)) OVER (PARTITION BY `Clinic`, `Product`)

    Welcome!

    It looks like you're new here. Members get access to exclusive content, events, rewards, and more. Sign in or register to get started.
    Sign In

    Welcome!

    It looks like you're new here. Members get access to exclusive content, events, rewards, and more. Sign in or register to get started.
    Sign In

    Quick Links

    Categories