Sort a line chart by date? If X Axis and Y Axis already filled?

  • 0
  • 1
  • Question
  • Updated 4 years ago
  • Answered

Have multiple designs with errors.  Currently I have errors in the Y axis, and Design Names on the X axis.  I need the designs to be sorta by a completion date, which I have as a field.  However, there's no sorta available if I use Design Name already for the X Axis.  Is there any way to sorta the Design Names by the completion date field for a line chart?

Photo of Yang

Yang

  • 0 Points

Posted 4 years ago

  • 0
  • 1
Photo of QuickBaseCoach App Dev./Training

QuickBaseCoach App Dev./Training, Champion

  • 69,572 Points 50k badge 2x thumb
I have not explored the Line Graph options, but if you find no other solution you could create a field called [Completion Date YYYYMMDD - Design name] and use that field. (e.g. 20151117-iPhone7 secret design specs"  Let me know if you need help with the formula for that.
Photo of Yang

Yang

  • 0 Points
Wow, great suggestion.  This work around turned out great.  Thanks.
Photo of QuickBaseCoach App Dev./Training

QuickBaseCoach App Dev./Training, Champion

  • 69,572 Points 50k badge 2x thumb
Thx for letting me know