Hi everyone,
Sorry for being the noobest noob in Power BI.
I find the app to be so exciting and cool, however I started working on it just a week ago in order to track trends at work.
I am in deep trouble now :))
I want to track a bigger array of categories on a daily basis compared to a monthly average.
I work in customer service and I have to track trends preferrably by percentage, for categories of cases.
So I would like to have as the basis value of comparison the average day value calculated for the last month for example. I can pull out a report and do a pivot in excel for this and just have 2 columns 1. category name 2. category value
This one I would need to be calculated as a daily average to compare the daily stats of the categories vs. how many of these categories have entered daily on average.
A | B | C | D |
Categories last month | Values of category last month | Categories today | Values of categories today |
| Accessories features | 3 | Account issue | 3 |
| Accessories prices | 1 | Delivery issue | 5 |
| Account issue | 60 | Issue with getting gift/voucher/product for free | 8 |
| Account set up/change process | 31 | Order fulfilment | 3 |
| Age verification issue | 56 | Others | 1 |
| Bluetooth related | 1 | Positive (product related) | 1 |
| Broken device | 5 | Sticks features | 1 |
| Burnt Taste | 1 | Where to buy accessories | 1 |
| Cancel the order | 14 | | |
| Chargeability Battery | 52 | | |
| Components of the starter kit | 3 | | |
| Corporate Enquiry | 1 | | |
| Data access request (DSR) | 1 | | |
| Deleting consumer account | 1 | | |
| Delivery issue | 245 | | |
| Delivery query | 10 | | |
| Device alarm indication | 3 | | |
| Device constant reboot | 12 | | |
| Device features | 26 | | |
| Device not working | 35 | | |
| Device Prices | 1 | | |
| Device replacement due to consumer fault | 3 | | |
| Device stop working | 53 | | |
| Device vibration | 5 | | |
| Difference with Competitors | 1 | | |
| Durability Battery | 7 | | |
| Excessive heat in charger (heat injury) | 1 | | |
| Excessive heat in device (heat injury) | 11 | | |
| Excessive heat in vapor (heat injury) | 6 | | |
| Front panel | 6 | | |
| Functionality Cover | 17 | | |
| How to charge | 1 | | |
| How to find the referral code | 9 | | |
| How to place an order | 9 | | |
| How to register device | 10 | | |
| How to use device | 7 | | |
| Ingredients/Components | 5 | | |
| Issue with getting gift/voucher/product for free | 204 | | |
| Issue with placing the order | 33 | | |
| Issue with product availibility/OOS claim | 5 | | |
| Issues with accrual of points | 2 | | |
| Issues with device registration | 15 | | |
| Job request | 3 | | |
| LED indication | 79 | | |
| Mechanics and conditions | 101 | | |
| Miscellaneous Accessories | 1 | | |
| Miscellaneous Device | 39 | | |
| Miscellaneous Sticks | 43 | | |
| New Supplier Proposal | 5 | | |
| Order fulfilment | 69 | | |
| Order issue/incorrect item | 22 | | |
| Other (provide comments) | 18 | | |
| Other Service issue | 1 | | |
| Others | 186 | | |
| Portfolio expansion | 4 | | |
| Positive (other) | 11 | | |
| Positive (product related) | 26 | | |
| Product launch date | 28 | | |
| Product Specification/Producer | 1 | | |
| Refund issue | 3 | | |
| Removing from 3rd party database | 128 | | |
| Replacement delivery issue | 2 | | |
| Request for return | 29 | | |
| Request for Trial | 3 | | |
| Return & Refund conditions | 18 | | |
| Service issue | 3 | | |
| Service Proposal | 34 | | |
| Site crashed | 3 | | |
| Spam | 8 | | |
| Sticks features | 22 | | |
| Sticks Prices | 3 | | |
| Store locator issue | 1 | | |
| Taste | 4 | | |
| Tobacco stick stuck in the device | 28 | | |
| Tobacco stick uneven heat distribution | 4 | | |
| Vapor generation | 6 | | |
| Visual appearance | 1 | | |
| Warranty & replacement conditions | 10 | | |
| Where to buy accessories | 8 | | |
| Where to buy device | 17 | | |
| Where to buy sticks | 41 | | |
Stats would kind of look like this.
So if the category from column C is found in column A, then I would like to see see a percentage increase/decrease of its value (D) vs. the average of the values from the last month (values fro column b ivided by 31.
Many many many thanks in advance!
