search

ivylabs / suitecrm-analytics

4 stars 4 forks source link

Average Call Duration - Average Total Row doesn't match with the Month Row, The Modules appear to be misaligned #305

Closed johnM2401 closed 3 years ago

johnM2401 commented 3 years ago

Describe the bug It appears that the Cases/Leads Modules are misaligned for the Month and "YYYY Average Total" rows on the Average Call Duration Report's Tables

See screenshots for examples.


**Component What component does this bug relate to?

  1. Report - Average Call Duration Report


**Solution File AverageCallDuration.prpt


To Reproduce Steps to reproduce the behavior:

  1. Add Call data for either Cases or Leads, so that an Average is calculated
  2. Pull this to the dwh with the ./run script
  3. View the Average Call Duration Report


Expected behavior The Data should match with the correct Module


Screenshots I only have Call data for Cases: image

But the "Total Average" shows below Leads

If I then add Call data to Leads, the Average appears below Cases: image

harrisward commented 3 years ago

Good spot. Fixed. Can you test the branch please @johnM2401

harrisward commented 3 years ago

Feature Branch: https://github.com/ivylabs/suitecrm-analytics/tree/feature-305 Pull Request: https://github.com/ivylabs/suitecrm-analytics/pull/306

johnM2401 commented 3 years ago

Hey @harrisward

Looks good, averages all adding up and aligned with the correct columns now

Can be merged to master