Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Hi, I have created a measure (% next day business) based on most recent 12 weeks. I need to now capture and show that percentage on a weekly basis. Is this possible being that it is a percentage? Here is the formula for the measure:
Hi @Anonymous,
Can you share a sample, please?
What is the result exactly? You already have the formulas. You can add the measure in the Y-axis and the Weeks in the X-axis. You can get the result finally.
Best Regards,
Dale
Hi Dale, my base data table is at an item number level and contains item number, account, order date and number of days it takes for a shipment to go from point A to B. The aggregated data is like this:
Account Code | Current 12 Week Ships % Next Day |
1008 | 76.92% |
1081 | 25.00% |
1091 | 61.54% |
1145 | 86.46% |
3589 | 85.80% |
3594 | 100.00% |
3600 | 100.00% |
3677 | 92.04% |
7960 | 95.01% |
These percents are based on the most recent 12 weeks. What I am trying to achieve is to calculate these percents again each week for the past 12 weeks to display on a trend line. Currently if I add it to a line graph, it results in a straight line. Apologies, I am not sure how to copy the graph here.
Hi @Anonymous,
Can you share your file if that's possible? You can upload it to the cloud drive like OneDrive then share the download link here. Please mask the sensitive parts.
Your data should be like this.
Account Code Week Current 12 Week Ships % Next Day
1008 | 2018-31 | 0.75 |
1008 | 2018-32 | 0.82 |
1008 | 2018-33 | 0.95 |
1008 | 2018-34 | 0.26 |
1008 | 2018-35 | 0.36 |
1008 | 2018-36 | 0.85 |
1008 | 2018-37 | 0.95 |
1008 | 2018-38 | 0.56 |
1008 | 2018-39 | 0.64 |
1081 |
The visual should be like this.
Isn't it?
Best Regards,
Dale
User | Count |
---|---|
140 | |
113 | |
104 | |
77 | |
65 |
User | Count |
---|---|
136 | |
117 | |
101 | |
71 | |
61 |