Forum Discussion
Last 12 Months Graph not working for DIVIDE - Please Help
Im currently trying to create a CurrentMonthTotal and a Last12MonthsTotals Graph that look like the image below.: I have 4 values that I use to calculate this number: _M_LocationID =...
Here you go .. thank you.
| _M_Avg#ReviewsByLocation | _M_LocationID | _M_ReviewID | Year | Month |
| 1 | 1 | 1 | 2019 | January |
| 1 | 1 | 1 | 2019 | February |
| 1 | 1 | 1 | 2019 | March |
| 1 | 2 | 2 | 2020 | January |
| 1 | 2 | 2 | 2020 | September |
| 1.2 | 9 | 11 | 2020 | October |
| 1.3 | 12 | 16 | 2020 | November |
| 1 | 7 | 7 | 2020 | December |
| 1 | 5 | 5 | 2021 | January |
| 1 | 4 | 4 | 2021 | February |
| 1.3 | 6 | 8 | 2021 | March |
| 1.3 | 7 | 9 | 2021 | April |
| 1.3 | 8 | 10 | 2021 | May |
| 1.2 | 10 | 12 | 2021 | June |
| 1.3 | 12 | 16 | 2021 | July |
| 1.4 | 12 | 17 | 2021 | August |
| 1 | 2 | 2 | 2021 | September |
Ashish_Mathur
Super User
Super UserHi,
Please also show the expected result (as requested in the previous message).