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

domoexpert

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

GrantSmith

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.

MichelleH

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

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

GrantSmith

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`)

domoexpert

Still not letting me save the card

GrantSmith

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.

MichelleH

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

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