Best Of

Ah the reason I'm not a fan of TIMEDIFF. In cases like this I prefer to use UNIX_TIMESTAMP and math to calculate the difference in seconds between two different timestamps.

SUM((CASE

  WHEN ((UNIX_TIMESTAMP(`Start Time (UTC)`) - UNIX_TIMESTAMP(`Arrival Time (UTC)`)) / 60) <=10 THEN 1

  END))

  /

  SUM((CASE WHEN `Case Number` is not null then 1

  end))

One question of clarification - If a start time comes 15 minutes before the arrival time (-15 minutes) should that be included since -15 < 10 or should it be excluded since the absolute duration is greater than 10? If it should be excluded you can wrap the subtraction in the ABS function to get the absolute value.

Hi @GrantSmith, thank you very much for your help. I set the number of rows from "Filter and Sort" in Analyzer and I was able to solve our problem!

You can create a beast mode and use that in your card instead of the field containing the number.

CASE WHEN number = 1 THEN 'Insufficient'

when number = 2 THEN 'Regular'

when number = 3 THEN 'Sufficient'

when number = 4 then 'Outstanding'

end

You'd replace "number" with whatever your field name is.

Agree with @jaeW_at_Onyx . I often use a heat map for this type of work. See below.

@ramoshe if you want categorical values on the X and Y axis you'd need a different chart type.

Consider a heat map. or pivot table

For future reference this is mentioned just above the "Customizing Pivot Tables" section in the knowledge base: https://domohelp.domo.com/hc/en-us/articles/360043429473-Pivot-Table#3. By default there's a limit of 25,000 rows to display. See the section " What are the DataSet row limits for each chart type?" on this article: https://domohelp.domo.com/hc/en-us/articles/360042924214-Card-Building-FAQs

Hi @Tow, it's likely that your pivot table has too many rows to process from the size of data being pulled in. In order to fully build the Pivot, the number of rows would need to be reduced.