-
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…
-
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?
