[CoE Starter Kit - BUG] Production_CoEDashboard usage report shows weekly instead of monthly

MartinWGT commented 9 months ago

Does this bug already exist in our backlog?

[X] I have checked and confirm this is a new bug.

Describe the issue

The Power BI report 'ProductionCoEDashboard{date}' has a very useful view of app usage. This shows usage per month but the report is displaying the data by week. As a result data over 2 months can appear in 1 month e.g. Dec and Jan below

This can easily be fixed by selecting the Month property in the report as shown below

Expected Behavior

The usage report display the monthly data by month instead of by week.

What solution are you experiencing the issue with?

Core

What solution version are you using?

Production_CoEDashboard_January2024

What app or flow are you having the issue with?

Production_CoEDashboard_January2024

What method are you using to get inventory and telemetry?

Cloud flows

Steps To Reproduce

Open the Production_CoEDashboard_January2024 report. Click on Apps (Deep Dive) Right click an app and select 'Drill through -> Review app usage' The app usage report shows weeks instead of months

Anything else?

No response

AB#2174

Jenefer-Monroe commented 9 months ago

For the upcoming Feb release, we switched this to be a hierarchy view as shown here.

MartinWGT commented 9 months ago

Will we still be able to see monthly totals, as this is a useful especially when forecasting usage for pay as you go set-ups.

Jenefer-Monroe commented 9 months ago

PBI hierarchies allow you to drill up to monthly. We can add a feature request around paygo predictions though if you'd like.

MartinWGT commented 9 months ago

Yes please. Azure billing gives a forecast for the whole environment, but it would be good to have this at the app level.

microsoft / coe-starter-kit