Creating a sensor from other sensor values

Configuration
,
1

I’m having trouble searching for/ explaining what I’m after and I’m hoping someone can guide me in the right direction.

I have a 3D printer which reports a serial number, color, material, and filament remaining for the currently loaded spool of filament. I would like to use this data to build a table of all my spools and their last-seen data. I’m not quite sure how to approach this, or if it’s even possible.

Here’s what the spool sensor reports:

1000007916
10000079161080×1535 149 KB

What I am trying to create would be somewhere I can see a list of all the recently seen spools, along with their color / filament remaining / etc. That way I don’t have to go rummaging around in my closet to see how much yellow I have left. I have literally dozens of rolls, each with a unique serial number reported.

I know you can use a sensor template to create a sensor from attributes, but that seems like something you’d use in a one-off, rather than wanting to build a database of values like this.

Any help in the right direction would be much appreciated.

2

I suspect this is too niche for anyone else to need, but I did set up influxdb to record the sensor data. The learning curve on influxdb is a little steep for me, so I haven’t quite figured out the right query for what I need, but the bigger issue is that I don’t see an obvious way to feed a table of data back as a sensor. If anyone has suggestions I’d appreciate them!