This article will provide the steps necessary to find the average Meld rating per vendor using the reports available in Property Meld.
Video demonstrations:
Written Instructions:
Step 1: The Filter- first we will create a filter so all of the melds will meet our desired criteria.
1a: Click on the melds tab in the top navigational bar and click the drop-down arrow next to the word FILTER.
1b: Select the criteria that you want the Melds in this report to meet. For mine, I want the Melds to have been created last month and have a resident rating of any stars.
1c. I recommend saving this filter so you can easily pull the report any time you need updated data. You can save the filter by, scrolling down to the bottom of the filtering options pop-up box and clicking Apply Filters. Then, click Save at the top of the page, enter the filter's new name and click Save Filter.
Step 2: Calculating the Average Rating- now that we have made the filter we can export the report and calculate the rating.
2a: Click Export CSV. This will automatically email a report of all Melds in your filter to the email you are signed in with.
2b: Locate the email and click Download File, then open the file.
2c: Once opened delete all columns except for V and Z or copy columns V and Z onto a new sheet. Then, use the custom sort option to sort the Assignee column in ascending order.
2d: Insert a row between each separate vendor. Then, highlight the Meld ratings for one vendor and click the dropdown arrow next to the AutoSum option on the Home tab and select Average. This will auto-fill the empty cell with the average rating.
2f: Repeat for each vendor.