-
Beastformula
I have this data with an ID column that are repeated because each unique id have 4 different event type, What I am trying to achieve is if one id with = 4 different category and are all completed in the event status column and within 45days of event date and originalenrollment date then it is completed. I have this code…
-
Table Chart and data validation
I create my table chart with beast mode fomulae, everything looks good, but when validating the data with the numbers populating in the table chart it is not accurrate. the beast mode formula seems to be correct. Can you help or any idea of what could be wrong. Thanks!
-
Beast mode formula
if "event type" is not equals to "current physical due" but the the "enrollment date" is still within 90days from today then its consider as pending and here is my formula: CASE WHEN Event Type <> Current Physical Due AND ABS(DATEDIFF(NOW(), Enrolled Date)) < 90 THEN 'pending' ELSE'' END but it's not working, please help!
-
Charts/Graph by
I want to display a bar chart with X axis = location and Y axis = total hours for each location but I want be able to view the data by month, week and day. I do have a date column. what is the best way to do this, the graph by option is not working.
-
beastmode
I working on a categorical text dataset with thousand of rows, I have a text column called 'indicatortext' with 21 distinct values , I have another column called 'result' with 7 distinct values, I want to create a table with indicatortext as the row and the percentage occurrence of one of the categories in result column,…
