Forum Discussion
Helper IITotal Revenue Per Month
Hello,
I have an issue that I can't seem to figure out. I'm trying to create a measure that would calculate the total revenue for each month on a line graph. Currently all I can accomplish is getting the graph to show the total of the new activations for the month. Below is a sample of the data I'm pulling from.
| Account | Account Number | Agent | Effective Date | Effective Thru Date | Priced Amount | USOC Description | USOC Code |
| John Doe | 12345678-9 | Jackie Jamison | 1/1/2018 | 3/5/2018 | $2.99 | AVG AntiVirus | CRAVGRECREST |
| Jane Doe | 32145678-9 | Jackie Jamison | 12/8/2015 | $5.00 | Personal Basic Backup | CRPERBASBAK | |
| Fred Smith | 98765412-3 | Scott Hatterfield | 3/3/2017 | 9/27/2017 | $2.99 | AVG AntiVirus | CRAVGRECREST |
| Bill Gates | 18342978-8 | James Cross | 5/4/2016 | 12/30/2016 | $2.99 | AVG AntiVirus | CRAVGRECREST |
| Josh Smith | 45698712-3 | James Cross | 8/4/2017 | $5.00 | Personal Basic Backup | CRPERBASBAK | |
| Mario Lopez | 95175348-2 | Mary Dod | 5/18/2016 | 12/29/2016 | $2.99 | AVG AntiVirus | CRAVGRECREST |
| Frank Nelson | 16589548-2 | Mary Dod | 5/18/2016 | 5/9/2017 | $5.00 | Personal Basic Backup | CRPERBASBAK |
For example on the line graph if i graph it for this month April 2018 then it should show the totals of Jane Doe & Josh Smith. But currently it is pulling zero. I've created a new group(bin) from the effective date and have the dates broken out per 1 month.
Any feedback would be appreciated. Thanks!
1 Reply
v-piga-msftResident Rockstar
Hi mattyj2009,
I am a liitle confused about why ' if i graph it for this month April 2018 then it should show the totals of Jane Doe & Josh Smith. ' and your Total Revenue, could you describe in more details about your scenario, so that we can help further investigate on it?
Best Regards,
Cherry