What kind of data structure Line Chart query expected for?

[HowieChih]

dashpress info

DashPress Version --- v1.1.3(Latest Version)

Node Version --- 22.1.0

question

I have a script to generate bill amount per day Line Chart as belows

return await $.query(`
select 
  count(*) as value, bill_begin_time
from organization_bill group by bill_begin_time limit 5
`);

and the query return data structure successfully as belows

[
  {
    "value": 4,
    "bill_begin_time": "2024-04-28T16:00:00.000Z"
  },
  {
    "value": 4,
    "bill_begin_time": "2024-04-29T16:00:00.000Z"
  },
  {
    "value": 1,
    "bill_begin_time": "2024-03-29T16:00:00.000Z"
  },
  {
    "value": 1,
    "bill_begin_time": "2024-03-30T16:00:00.000Z"
  },
  {
    "value": 1,
    "bill_begin_time": "2024-02-28T16:00:00.000Z"
  }
]

but Preview tab has nothing showed and Create Dashboard Widget won't work either.

Wanna figure out is there anything wrong with query script? What kind of data structure Line Chart query expected for to make it work properly? Any information would be great to hear, thanks for your time.

[thrownullexception]

Hi @HowieChih, Line chart is a Pro feature, for the free version, you can only generate tables and summary cards

https://dashpress.io/pricing is the link to the pricing page, you will see the free features and the paid ones

[HowieChih]

Will check out. It would be better if there are some description to indicate Charts are Pro features when using them with community edition.

[thrownullexception]

Hi @HowieChih, I was just able to see the problem you were describing, That is a bug, the chart types shouldn't show unless you upgrade to the PRO version. I have fixed this issue and those three options will no longer show on the free version