Bug #5593

Bug #5525: Dashboard

Dashboard - query

Added by Lim Leonard almost 9 years ago. Updated almost 9 years ago.

Status:Work Completed-End life cycleStart date:October 27, 2015
Priority:NormalDue 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

Also available in: Atom PDF