Questions about the Ossinsight analyze-recent-issues API

Translated
1

Note:
This topic has been translated from a Chinese forum by GPT and might contain errors.

Original topic: Ossinsight analyze-recent-issues API 疑问

| username: TiDBer_FTB0oqK1

How should we understand current_period and last_period, and what does each field correspond to?

2
| username: jansu-dev | Original post link

I don’t quite understand OSSInsight, but I looked in the repo → feat(sql): add repo last 28 days queries by Mini256 · Pull Request #697 · pingcap/ossinsight · GitHub
From the PR, I think I can guess the meaning of the SQL; :sweat_smile:

3
| username: TiDBer_FTB0oqK1 | Original post link

@Miniant256 I can’t understand the SQL. Could you please briefly explain the meaning of each field?

4
| username: hooopo | Original post link

Combining the page makes it easier to see. From the current time to 28 days ago is one cycle, and the previous cycle is from 28 days ago to 56 days ago.

5
| username: TiDBer_FTB0oqK1 | Original post link

Thank you. I understand that current_period_opened_issues refers to the number of issues opened from today to 28 days ago, but what does current_period_opened_day_issues mean?

6
| username: jansu-dev | Original post link

From the SQL in the PR, the total is the sum of the issues;
If current_period_opened_issues → the total number of issues opened from today to 28 days ago
Then current_period_opened_day_issues → the number of issues opened each day from today to 28 days ago

image
image688×647 106 KB

PTAL @hooopo thx

7
| username: system | Original post link

This topic was automatically closed 60 days after the last reply. New replies are no longer allowed.