I am new in Dynamics 365 for Office 365. I need to create a dashboard based on all task activities.
All tasks Key fields:
1.Task name
2. Day late ( such as 20, -2 ), 20 will be early, -2 will be late
3.Product Category ( Regarding type coming from opportunity )
Table looks like this:
|
Task name
|
Day late
|
Product Category
|
Notes
|
|
Task1
|
-2
|
Cat1
|
Late completed
|
|
Task2
|
1
|
Cat1
|
Early completed
|
|
Task3
|
-20
|
Cat2
|
|
|
Task4
|
3
|
Cat2
|
|
|
Task5
|
-12
|
Cat3
|
|
|
Task6
|
0
|
Cat3
|
On time
|
|
Task7
|
0
|
Cat2
|
|
|
Task8
|
6
|
Cat1
|
|
Dashboard will be used to track the task status, as:
Total early tasks and each category percentage ( will be day late > 0 and group by category )
Total late tasks and each category percentage ( will be day late < 0 and group by category)
Total on time tasks each category percentage ( will be day late =0 and group by category )
How to do this kind of group by dashboard chart in Dynamics 365 for Office 365?
