-
Grand Total to Show as Average instead of Sum
I'm trying to get my Grand Total for Revenue as an example to show as an average instead of a sum in a Mega Table. My Revenue calc is below. SUM (CASE WHEN (`Source` = 'Order Items' AND `OrderItems.Type` = 'SpaceOrder' AND `Rank_DateRunOrderItems` = 1) AND `Reservation.State` != 'Canceled' AND `Enterprise.Name` IS NOT NULL…
-
Formatting on Dashboard
Has anyone ever seen this? One of my cards extended further to the right pane on the dashboard than all the others and I'm unsure why. Don't know if I accidentally hit something on the keyboard or a shortcut, but I can't get it to go away. Would also like to know how I did it so maybe I can make my dashboard wider without…
-
Line Break in Beastmode
Is there a way to write a beastmode that puts strings on the next line? For example if I have 3 fields (First Name, Middle Name, Last Name), I want it to show up like this… First Name Middle Name Last Name and not like this First Name Middle Name Last Name.
-
Format Numbers at the ETL Level
Does anyone know if it is possible to change the formatting of a number at the ETL level instead of on each inidivual card? For example, changing a number that is currency so it shows up with the $ instead of just a number…
-
Make 1st letter of a field value uppercase in ETL
Is there a way to make the first letter of a value in a field uppercase? Not the entire word, just the first letter…
-
Date Calculation
How do I write a calculation to return the same date but for next month? For example, if the date showing is December 4, 2024, how do I return January 4, 2024?
