This topic is locked

Chart date range

3/28/2021 2:40:42 PM
PHPRunner General questions
S
SteveA author

Hi All

I have a line chart, extracted from mysql

date : single data element

I want to display my date axis from earliest to latest ( LTo R)

I am resticting records to 6 if i switch filter to asc. i get the last six in table, I need first six ( by date) displayed earliest to now

My lists and reports are fine using the DESC sort on the query panel

Any suggestions, I have a total block on the charts

Thanks in advance

M
Mark Kramer 3/31/2021

Change your sort order to "decending" in your query of that table. I think you use the "BeforeQuery"