Jump to content
  • 0
DesiLogi

Line Chart with multiple fields across month rollup

Question

I’m trying to create a line chart that tallies monthly totals for 2 things (separate fields in the same table): customer signups and customer cancels, by month.

In the data source each record is a customer with a field for the Date_Submitted (signup) and a field for Cancel_Date (if they canceled, it will be blank if they didn’t). 

I can do a separate chart for each of these, using either date for the Category (so I can get a monthly rollup) and a 'count' for the # of companies in the value section. But I need to combine these charts into one- so across a monthly rollup there's a 'line' for # of Date_Submitted and another 'line' for # of Cancel_Dates.

The problem is that for the X axis (category) you have to choose either/or date field in order to get the chart to span by months. How can I get a rollup by month without choosing one of the date fields? How can I get a 'count' of each time Date_Submitted and Cancel_Dates fall within each month? These charts are really frustrating to work with and any help would be greatly appreciated. 

 

Share this post


Link to post
Share on other sites

8 answers to this question

Recommended Posts

  • 0

Hi MayMusic,

Thanks for that tip- I hadn't thought about that and will give it a try. If I can show the number of signups and number of cancels over the month this way that'd be awesome. I'll post back on this thread about that- 

Share this post


Link to post
Share on other sites
  • 0

It’s a high-quality importance idea… merit in move to the rear for your point in time..  I feel friendliness for this development so a superior arrangement..

_________________________________________________

Linenandbedding

Share this post


Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now


×