ADAPT Inactive Time Dashboard

Q&A
,
1

For Inactive Time STUs - In ADAPT there is a Gap Time and Adjusted Gap Time column. The ADAPT Inactive Time Dashboard only shows Gap Time. Can the Dashboard also pull the Adjusted Gap Time?

Screenshot 2025-10-16 at 00-33-12 kyrinawi@ - ADAPT
Screenshot 2025-10-16 at 00-33-12 kyrinawi@ - ADAPT348×290 1.3 KB

2

Hi @rilemroz

Welcome to the community!

Can you please elaborate your query in a little more detail so we can understand your requirement/problem and respond accordingly?

3

If looking at the Excel pull from the Dashboard it shows all data points being pulled from the ADAPT Website except the Adjusted Gap Time. Is there a way to get that data also to pull into the Quicksight Dashboard?

image
image1286×455 15.2 KB

4

As you can see in this snip from the Website itself, the Adjust Time Gap is shown here but again, not in the Quicksight Dashboard

image
image1905×418 37.2 KB

5

Hi @rilemroz

To get difference in minutes between two dates, you can use dateDiff function.

For Adjust Time Gap, you need to write ifelse calculation based on how it has been calculated in the Website.

Example:

dateDiff(OrderDate, ShipDate, "MI")

ifelse(
    {Status} = 'Exempted', 0,
    {Status} = 'Partially Exempted' AND {Exemption Reason} = 'Went to Amcare/Wellness', {GAP Time} - 10,
    {Status} = 'Not Exempted', {GAP Time},
    {GAP Time}
)
6

Hi @rilemroz

It’s been a while since we last heard from you. If you have any further questions, please let us know how we can assist you.

If we don’t hear back within the next 3 business days, we’ll proceed with close/archive this topic.

Thank you!

7

Hi @rilemroz

Since we have not heard back from you, I’ll go ahead and close/archive this topic. However, if you have any additional questions, feel free to create a new topic in the community and link this discussion for relevant information.

Thank you!