I have a query that returns three columns (and now() as time_sec):
±--------------------±---------±--------------------------±-------------------------+
| time_sec | count(*) | department | job |
±--------------------±---------±--------------------------±-------------------------+
| 2019-09-03 15:17:31 | 2 | Warranty | Onsite Service |
| 2019-09-03 15:17:31 | 14 | Maintenance | Preventative Maintenance |
| 2019-09-03 15:17:31 | 1 | Maintenance | Firmware/Software Update |
| 2019-09-03 15:17:31 | 230 | Maintenance | Onsite Support |
| 2019-09-03 15:17:31 | 1 | Maintenance | Phone Support |
| 2019-09-03 15:17:31 | 5 | T&M | General |
select now() as time_sec,
count(*) as value,
department,
job,
from table
group by department, job
I’m trying to make a stacked bar chart where, for example, ‘Maintenance’ is on the X axis and the values are stacked by ‘job’.
Right now with ‘Format as’ Time Series, X Axis as a Series (Total) I get an error “Value column must have numeric datatype, column: job type: string value:”