Forum Discussion
Reporting Trends Over Time
Hello,
As of now my team is using a Power BI to look into ticket work flow on a daily basis. This is useful, however we have very little insight into our performance over time. I am looking to report on team trends and improvement on a weekly, monthly, quarterly, annual basis. I assume we would need to create some kind of data log that we would reference in Power BI. Does anyone have any insight into how that may work? Our data comes from Micro Focus Service Manager.
Thank you.
Hi Anonymous ,
You could use visualizations to show your data changes over time( like clustered column chart, line chart and area chart etc. ).
Here is the ducument for your reference. You could find description of each official visual.
https://docs.microsoft.com/en-us/power-bi/visuals/power-bi-report-visualizationsThen make time field as the x-axis and make value as y-axis to show the trend.
And you could use date hierarchy to show data for different time periods.
3 Replies
- Greg_Deckler
Community Champion
Check out Open Tickets Quick Measure: https://community.powerbi.com/t5/Quick-Measures-Gallery/Open-Tickets/td-p/409364
It was designed to do what you are saying with just start dates and end dates.
- amitchandak
Super User
Please refer to my blog on similar like :https://community.powerbi.com/t5/Community-Blog/HR-Analytics-Active-Employee-Hire-and-Termination-trend/ba-p/882970
Appreciate your Kudos.
- v-eachen-msft
Community Support
Hi Anonymous ,
You could use visualizations to show your data changes over time( like clustered column chart, line chart and area chart etc. ).
Here is the ducument for your reference. You could find description of each official visual.
https://docs.microsoft.com/en-us/power-bi/visuals/power-bi-report-visualizationsThen make time field as the x-axis and make value as y-axis to show the trend.
And you could use date hierarchy to show data for different time periods.
