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

Options
domoexpert
domoexpert Member
edited July 7 in Calculations & Variables (Beast Mode)

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

Tagged:

Best Answers

  • GrantSmith
    GrantSmith 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!**
  • MichelleH
    MichelleH Coach
    Answer ✓

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

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

Answers

  • GrantSmith
    GrantSmith 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:

    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!**
  • domoexpert
    domoexpert Member

    Still not letting me save the card

  • GrantSmith
    GrantSmith 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!**
  • MichelleH
    MichelleH Coach
    Answer ✓

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

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

Categories