-
Group by Percentage
Hi there! I'm trying to figure out how to get the percentage of rejected x-ray images by reject reason. I built a simple ETL that gives me the count of rejected images by reason for each type of x-ray (body part) along with the total # of x-rays for that body part (Acquisition). I'm stuck on how to get the % of rejects per…
-
Managing Access Groups
Hi there! I'm looking for some advice on how to best manage users and Access Groups within Publication Groups. Is there a way to access the list of users found under "People" in Admin? I know I can manually do a bulk export but that is cumbersome and obviously can't be scheduled etc. We use Publication Groups and Access…
-
Help with Beast Mode
Hi there, I'm a newby with Beast Modes and could use some help please! I created this Beast Mode which tells me the reject % for January. It works fine but I would like to modify it so it gives me the YTD average. Any help would be really appreciated. THX!!! CASE WHEN ifnull(SUM (CASE WHEN `Month` = '1' AND `Event Name` =…
-
Beast Mode to change value in Column A based on Value in Column B
Hi there! I have a table that includes a Site ID column and a Site Name Column. I want to change the Site Name when the Site ID = x. I have the following code which works but it creates a new column but I don't want a new column, instead I want to change the Site Name in the existing site name column. Many thx in advance!…