Skip to main content
Question

two value fields in graph

  • July 24, 2019
  • 0 replies
  • 14 views
Hi All

situation


Field1    Jan 2018     Jan 2019   Feb 2018    Feb 2019
AAA         10               25              11                      45 
AAA          10              22              45                      09
AAA          14              14              11                      22
CCC         18              77               21                     11




 
Graph Needed:






The graph for AAA showed in the above chart. 
I have searched for all possibilities in reports and charts, but cannot achieve it. also tried to denormalize.(no use).

Any ideas guys.

      This topic has been closed for replies.

      This should be possible. Make a field to calculate the month in the format

      01
      02

      Or else if you order

      01-Jan
      02-Feb

      They need to sort alpha, hence the numbers.

      Make a field to calculate the Year.

      Then you chart can show the X axis as the month and the series as the year.
      Terms & ConditionsAccessibility statement