-
Change background/format of report
Hi Is there a way to change the background of a report? I have an image fill background on the dashboard with white text. When the reports come via email they show a light grey background with white text which is hard to view. The Dashboard background is our company standard so that cannot be changed.
-
Case Statement with Count Distinct
Hi I am trying to write a case statement to find how many individuals are admitted (so admitted = admission date present AND discharge date and decreased dates are blank). I have this so far: Count (DISTINCT Case when (STATUS = 'Admitted') AND DISCHARGEDDATE IS NULL AND DECEASEDDATE IS NULL THEN IDFFORMID END I want to…
-
Case Statement help
I have an ETL with several joins and calculations. My final output is good except for this last piece: I would like to identify in a formula that when the "ID" column has the same # but the "Status" column is different, then I want to keep the status result from the "last update date" column. Is there a formula I can use…
-
I am trying to remove duplicates so that I only count the result of the last batch run
Hi can anyone tell me how to write the forumla for this? I tried to add a formula to the ETL but did not know what formula I would need as I wasnt successful with any I tried and I'm a novice! 😪
-
How do I sort my time of day ranges on a card so it is in chronological order?
I created a time of day beast mode below which works successfully. I am using a bubble chart to show the time od day most events occur. This also works successfully however, I would like to be able to sport my time of day in chronological order. I have tried to use the beast mode created below in the sort as both assending…
