Jenna

HOUR(TIMEDIFF(Verification/\nCommunication\nSent, Intake/Auth Req Received)) This returns just the hours, I tested it using data with 2 Timestamps

in Calculating Time Diff (in hours) over Multiple Days Comment by Jenna April 3

Maybe Try TimeDiff((Most Recent Date),(Oldest Date))

in Calculating Time Diff (in hours) over Multiple Days Comment by Jenna April 3

Can you give an example of what you are wanting your dataset and new column to look like?

in Help with creating just one single column containing different time frames Comment by Jenna March 27

April, May, and June, do not have visits. My end goal is to use March's Visits/ Work Day * each month's Work Day to get forecasted visits. This is a test of the logic that will be applied to more in depth formulas with interactive variables. I updated the formula to what you suggested and its returning the same values.

in Forecasting Next Quarter's Data Comment by Jenna March 27

This is the formula I used to test the logic for next month, This is the data its returning. I want it to show March's Data for April-June as well, Thank you!

in Forecasting Next Quarter's Data Comment by Jenna March 27

I am trying to do something similar, but I am wanting to use my current month's data/working day to project the total visits for next month. The formula I have below is how im calculating current month: (SUM(case when Appointment Status = 'Arrived' then Visit Count end) / (MAX(COUNT(DISTINCT case when Appointment Status =…

in If date falls within the current month Comment by Jenna March 27

Jenna Member

Comments