# Timeseries with Category Subplot possible? **URL:** \ **Category:** Ignition\ **Tags:** perspective\ **Created:** [April 11, 2024, 1:06am UTC](https://forum.inductiveautomation.com/t/timeseries-with-category-subplot-possible/88675 "2024-04-11T01:06:20Z")\ **Posts on this page:** 2\ **Page:** 1
**Author:** ![Eugene49](https://avatars.discourse-cdn.com/v4/letter/e/c6cbf5/32.png) [@Eugene49](https://forum.inductiveautomation.com/u/Eugene49)\ **Post date:** [April 11, 2024, 1:06am UTC](https://forum.inductiveautomation.com/t/timeseries-with-category-subplot-possible/88675/1 "2024-04-11T01:06:20Z")
I have a timeseries data (float) and another timeseries data (category, state). Is it possible to display State timeseries data on timeseries chart? ![image](https://us1.discourse-cdn.com/inductiveautomation/original/3X/a/e/aef2fd3885829832b57b8c980176f03348cf50fc.png) ---
**Author:** ![Transistor](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/transistor/32/3380_2.png) [@Transistor](https://forum.inductiveautomation.com/u/Transistor)\ **Post date:** [April 11, 2024, 8:21am UTC](https://forum.inductiveautomation.com/t/timeseries-with-category-subplot-possible/88675/2 "2024-04-11T08:21:14Z")
Probably the simplest would be to modify your SQL query to convert the state into an integer. Alternatively you could do it by script but it would be less efficient. I'd use ```auto -1 = Fault 0 = Off 1 = Running ``` Then anything above the line is time spent running and anything below the line is time spent in fault.