Bug #5593
Bug #5525: Dashboard
Dashboard - query
Status: | Work Completed-End life cycle | Start date: | October 27, 2015 | |
---|---|---|---|---|
Priority: | Normal | Due date: | ||
Assignee: | Najmi Pasarudin | % Done: | 100% | |
Category: | - | Spent time: | - | |
Target version: | - |
Description
Hi Najmi,
just the query need confirmation with najmi.
#target sale : source appoint already correct, it just that the source has no data (null) as no one updated it
#sale generated : source appoint already correct, it just that the source has no data (null) as no one updated it
History
#1 Updated by Najmi Pasarudin almost 9 years ago
- % Done changed from 0 to 10
Update:
1) Target sale column has been updated.
2) Generated sale column still pending due to Feedback table in development.
3) There are other charts query need to be checked.
#2 Updated by Najmi Pasarudin almost 9 years ago
Comment on Overall Dashboard (Based on UAT data):
1. In "IMPACT TARGET SALES VS SALES GENERATED BY PROGRAMME TYPE IN 2015" chart, there are sales generated shown in the chart.
However, in "IMPACT - ROI BY PROGRAMME TYPE IN 2015" chart, which calculate ROI = Sales Generated / Utilised Budget, sales generated is 0. Please check the query.(This also impact ROI dashboard)
#3 Updated by Najmi Pasarudin almost 9 years ago
Comment on Overall Dashboard (Based on UAT data):
1. In "IMPACT TARGET SALES VS SALES GENERATED BY PROGRAMME TYPE IN 2015" chart, there are sales generated shown in the chart.
However, in "IMPACT - ROI BY PROGRAMME TYPE IN 2015" chart, which calculate ROI = Sales Generated / Utilised Budget, sales generated is 0. Thus, showing nothing in chart. Please check the query.
(This also impact ROI dashboard)
Comment on Budget Dashboard (Based on UAT data):
1. Approved budget pie chart actualy showing utilised budget and Utilised budget is showing nothing. Please relocate the label and charts.
Note:
a. Approved budget pie chart should be same with Overall dashboard.
b. event_borang_p is for utilised budget.
Comment on Programme Dashboard (Based on UAT data):
1. "NUMBER OF APPROVED EVENT BY PROGRAMME TYPE IN 2015" shows nothing while the chart from Overall Dashboard shows there is data.
Comment on ROI Dashboard (Based on UAT data):
1. In "IMPACT - ROI BY PROGRAMME TYPE IN 2015" chart, which calculate ROI = Sales Generated / Utilised Budget, sales generated is 0. Thus, showing nothing in chart. Please check the query.
#4 Updated by Najmi Pasarudin almost 9 years ago
Updated comment:
1. Comment on Overall Dashboard (Based on UAT data):
- In "IMPACT TARGET SALES VS SALES GENERATED BY PROGRAMME TYPE IN 2015" chart, there are sales generated shown in the chart.
However, in "IMPACT - ROI BY PROGRAMME TYPE IN 2015" chart, which calculate ROI = Sales Generated / Utilised Budget, sales generated is 0. Thus, showing nothing in chart. Please check the query.(This also impact ROI dashboard)
Note:
a. Sample data for utilised budget added
2. Comment on Budget Dashboard (Based on UAT data):
- Approved budget pie chart actualy showing utilised budget and Utilised budget is showing nothing. Please relocate the label and charts.
Note:
a. Approved budget pie chart should be same with Overall dashboard.
b. event_borang_p is for utilised budget.
c. Sample data for utilised budget added
3. Comment on Programme Dashboard (Based on UAT data):
- "NUMBER OF APPROVED EVENT BY PROGRAMME TYPE IN 2015" shows nothing while the chart from Overall Dashboard shows there is data.
- New finding: Please add status completed and confirmed in the query
4. Comment on ROI Dashboard (Based on UAT data):
- In "IMPACT - ROI BY PROGRAMME TYPE IN 2015" chart, which calculate ROI = Sales Generated / Utilised Budget, sales generated is 0. Thus, showing nothing in chart. Please check the query.
Note:
a. Sample data for utilised budget added
#5 Updated by Najmi Pasarudin almost 9 years ago
- Status changed from New - Begin Life Cycle to Development / Work In Progress
- % Done changed from 10 to 100
Comments has been sent to Syahirman.
#6 Updated by Najmi Pasarudin almost 9 years ago
- Status changed from Development / Work In Progress to Work Completed-End life cycle