two value fields in graph

Question

Hi AllsituationField1&nbsp; &nbsp; Jan 2018&nbsp; &nbsp; &nbsp;Jan 2019&nbsp; &nbsp;Feb 2018&nbsp; &nbsp; Feb 2019AAA&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;10&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;25&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 11&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 45&nbsp;AAA&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 10&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 22&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 45&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 09AAA&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 14&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 14&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 11&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 22CCC&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;18&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 77&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;21&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;11&nbsp;Graph Needed:The graph for AAA showed in the above chart.&nbsp;I have searched for all possibilities in reports and charts, but cannot achieve it. also tried to denormalize.(no use).Any ideas guys.

quickbasecoachd · Answer

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.

Forum Discussion

two value fields in graph

Related Content

Find and Replace Field Values

Jinja If statement equals field value

Grabbing value between 2 fields

Color Coding based on field value

Address Field - Set default value?