Question

Why the threshold value is ignored for the Number type chart for the time metric?

Answer

The threshold value for Number type charts for time interval metrics is measured in seconds. The calculations are the following:

• second: 1
• minute: 60
• hour: 60 * 60
• day: 24 * 60 * 60
• week: 7 * 24 * 60 * 60
• month: 30 * 24 * 60 * 60
• year: 365 * 24 * 60 * 60

For example, the threshold value for 1 year and 6 months will be:

47 088 000 = 1 * (365 * 24 * 60 * 60) + 6 * (30 * 24 * 60 * 60)