on the object I have the following:
No of users
User - oped date
User - closed date
when a deal is closed the salesperson fills out the "user - open date" and the "no of users".
when the subscription is over they fill out the "user - closed date"
I want to show is one graph: the x axis - months, and the Y axis will show the amount of open and closed.
this is what is did so far but would like to combine
how do i do it in one graph?
thank you!!!!!
Tali
1 réponse
-
Hi Tali,
what you are trying to get is a bit difficult (not to say impossible) and here is how close I can get to:
mine is for cases created / closed by month but I believe it will apply to your users. My graph is showing number of open per month (the blue line) and when they were closed. for example: cases created in december '10 were closed in Jan'11, april'13 etc. which is reflected by different colours. The result graph:
And the settings:
If the above is good for you and need clarification, please let me know. ( the grouing in the report is first by Date open and under it by Date closed.
---
correction: the Group by should be date/time open.
