I have a data set which collects sensor data (messages) from a large number of sensors. Sensors send anywhere from zero to hundreds of messages per day and not consistently. The data is stored in an Oracle database with the following relevant fields:
I track the the total messages per sensor per day or per hour easily with Tableau.
What I want to do is to chart the accumulation of SensorIDs over the course of the day.
This means that I need to
1) To know how long it takes to detect all the sensors
2) What percent are detected in a day
3) How fast do we ramp up to near complete detection.
It seems that table calculations could play a role here but I am stuck.
I would appreciate any help.
One way to do this may be to use the window_sum function with your distinct count. Are you able to post a sample workbook (twbx file)?