Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago

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 =...
Need Help
Ashish_Mathur's avatar
Ashish_Mathur
Icon for Super User rankSuper User
5 years ago

Hi,

It is best to show some data (in a format that can be pasted in an MS Excel file) and the expected result in a Table format.

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    Here you go .. thank you.

     

    _M_Avg#ReviewsByLocation_M_LocationID_M_ReviewIDYearMonth
    1112019January
    1112019February
    1112019March
    1222020January
    1222020September
    1.29112020October
    1.312162020November
    1772020December
    1552021January
    1442021February
    1.3682021March
    1.3792021April
    1.38102021May
    1.210122021June
    1.312162021July
    1.412172021August
    1222021September
    • Ashish_Mathur's avatar
      Ashish_Mathur
      Icon for Super User rankSuper User
      5 years ago

      Hi,

      Please also show the expected result (as requested in the previous message).