I'm working through the demo and I'm having an iss...
# troubleshooting
b
I'm working through the demo and I'm having an issue with the line chart. Everything sems to be working but the chart component. ln50 <BarChart data = {orders_by_month} y=sales_usd0k title = 'Sales by Month, USD' /> The chart renders with the expected title and y values but no data. I tried adding x=date <BarChart data = {orders_by_month} x=date y=sales_usd0k title = 'Sales by Month, USD' /> but still nothing. Any suggestions?
b
Hmm interesting! 1. Have you edited the
orders_by_month
query at all? 2. What browser are you using 3. Can you see any errors in the browser (in opening developer tools) 4. What version of node and npm do you have
node -v
npm -v
?
Hang tight, we've actually reproduced this issue
b
Cool, Thanks!
b
Hey @best-king-86949 we've recently changed our date parsing logic which has caused this. We're working out what to do about it, but in the meantime if you change your query to:
Copy code
```orders_by_month
select
  substr(order_datetime,1,7) || "-01" as date,
  count(*) as number_of_orders,
  sum(sales) as sales_usd0k,
  sum(sales)/count(*) as average_order_value_usd2
from orders
```
This should solve it
Thanks for identifying this for us!
Extra info: Most databases have native date types. We can map these directly to JS types which works nicely. SQLite does not, and so all dates are effectively strings which we have to manually process to JS dates.
b
Thanks! That works.