Forum Discussion
Build graph to count active actions per week
Hi!
To show the status by week you need to have recorded in your database the history of changes every week. That is, every week you need to save the action, the status and the reference date (date or week the information was saved). Having that you can import this table into Power BI and create a chart with the date on the X axis, the status in the legend and create a metric using the COUNTROWS function to count the rows and add it on the Y axis for example.
Hi!
To show the status by week you need to have recorded in your database the history of changes every week. That is, every week you need to save the action, the status and the reference date (date or week the information was saved). Having that you can import this table into Power BI and create a chart with the date on the X axis, the status in the legend and create a metric using the COUNTROWS function to count the rows and add it on the Y axis for example.
Thank you so much
