Creating multiple lines on a single chart

Ignition
1

I have a dataset with a date, a categorical field with 3 levels and time spent doing an activity. I would like to plot three lines, once for each category in one chart. Any suggestions how to do this in ignition designer perspective? I have tried XY chart and time series charts and didn't go too far.

Ideas are appreciated. My dataset looks like this:
multiple line plot

I'd like my output to look like this:

multiple lines out
multiple lines out1378×762 51.4 KB

Thanks in advance!!

2

You can do this by creating a data source and series for each category.

3

You mean use query binding three times in this case? A query for each series?

Thanks for your response.

4

That would be the simplest - although it might not be the fastest.

5

What's a better/faster solution?

6

I imagine you could create a custom property with the query you have now, then use expression bindings on your individual data sources with Phil's Integration ToolKit Module. Though depending on your data it may plenty performant with individual queries.

7

Write one complex SQL query to return all the data in one trip versus writing three simple and easy to debug and maintain queries.