Skip to main content
Solved

Line graph with X axis as month

  • 31 July 2024
  • 1 reply
  • 31 views

Forum|alt.badge.img

I am trying to build a line graph widget to show opportunities by month year over year:

  • Lines by year (2022, 2023)
  • x-axis of each month - Jan, Feb, Mar, etc. 
  • y-axis quantity of opportunities 

I can’t get it to show generic months and have all years on the 12 months vs actual month 1-2022, 2-2022, etc.

Please let me know if you have a solution.

Thanks!  

Best answer by meganfriesen37

Hello,

I think in your underlying inquiry you’ll need to add two calculated columns. 

One where you use either the Month or MonthName formula to get the month.  If you want the months to be in order, you might need to mess around a bit with this, as I was getting 1, 10, 11, 12, 2, 3, etc. on my chart or April, August, December, Feb, etc. in Alphabetical order)

  • i.e. =Month([CROpportunity.CloseDate]) 

And another column where you are just splicing out the year

  • i.e. =Year([CROpportunity.CloseDate])
     

     

Then you should be able to put the items into your widget (make sure to put 12 as the total values for the Month so you get all of them).

And you should get a chart something like this:
 

 

View original
Did this topic help you find an answer to your question?

1 reply

meganfriesen37
Captain II
Forum|alt.badge.img+11
  • Captain II
  • 564 replies
  • Answer
  • August 28, 2024

Hello,

I think in your underlying inquiry you’ll need to add two calculated columns. 

One where you use either the Month or MonthName formula to get the month.  If you want the months to be in order, you might need to mess around a bit with this, as I was getting 1, 10, 11, 12, 2, 3, etc. on my chart or April, August, December, Feb, etc. in Alphabetical order)

  • i.e. =Month([CROpportunity.CloseDate]) 

And another column where you are just splicing out the year

  • i.e. =Year([CROpportunity.CloseDate])
     

     

Then you should be able to put the items into your widget (make sure to put 12 as the total values for the Month so you get all of them).

And you should get a chart something like this:
 

 


Reply


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings