MaunishP
Member
Hi Team,
I am creating a dashboard for my helicopter view, I was not able to think best what can be done from this pivot table and Dashboard output. I was looking for a Overview sheet which will show me all information in single go such as :
If I select Name it should show which team he / she belongs to along with how many projects are assigned under her / him.
How many projects data has " 0 " count. How many projects has < than target count. How many projects has data > than target count.
Bucketization for last time enter slab wise. Highest number of cases worked in a month, less number of cases worked in a month. Trend going up or down.
Increamental / Decremental count for each project whether cases are increasing by what number or decreasing by what number.
What more can i think. Not able to plot ideas on excel.
I have gone through Chandoo's many dashboard samples, and got more confused becasue all we best and excellent.
Hence I am asking you team, if you could plot this into overview.
Regards,
Maunish Patel
I am creating a dashboard for my helicopter view, I was not able to think best what can be done from this pivot table and Dashboard output. I was looking for a Overview sheet which will show me all information in single go such as :
If I select Name it should show which team he / she belongs to along with how many projects are assigned under her / him.
How many projects data has " 0 " count. How many projects has < than target count. How many projects has data > than target count.
Bucketization for last time enter slab wise. Highest number of cases worked in a month, less number of cases worked in a month. Trend going up or down.
Increamental / Decremental count for each project whether cases are increasing by what number or decreasing by what number.
What more can i think. Not able to plot ideas on excel.
I have gone through Chandoo's many dashboard samples, and got more confused becasue all we best and excellent.
Hence I am asking you team, if you could plot this into overview.
Regards,
Maunish Patel