How to connect tandem input with yes/no data type

[abiprayabim]

How to connect tandem input with yes/no data type

I want to create a connection that can display yes or no data for beds in hotels automatically via sensor data

[jessica_smith]

Hi @abiprayabim ,

String formatting, such as yes/no, on/off, etc. is not currently supported in Tandem. However, we are receiving this feedback more and more frequently, and the team is looking into it.

The current workaround for this is to use zeros and ones for such cases. We have had other customers do this.

Thanks for this feedback! You can view our published roadmap here, and submit feedback and feature requests on the same site by clicking + Submit Idea.

[abiprayabim]

nice to hear, is there a case story or tutorial used in cases 1 and 0?

[abiprayabim]

Nice to hear, is there a case story or tutorial used in cases 1 and 0? Hopefully there will be a case story or tutorial to make development easier

[derek_milz]

Yes, we've seen many tandem users using 1's and 0's for things such as occupancy monitoring of spaces + heatmap capability to display red/green.  Once your sensors are publishing the boolean (1 or 0) values to a connection/stream and that stream is pinned to a space - you can then use heatmaps.  In your heatmap settings, use a min value of 0 and a max value of 2 and the 'Green -Red' Color theme (sometimes you will have to use different min/max depending on your color use case).  That space should then go from red to green depending on the current value.

[l.bell5H8JW]

Hi @abiprayabim were you able to find a way to do this? We only have yes/ no or text being generated so it would be great to hear if you found the tutorial

[derek_milz]

You do need a program of sorts in the middle (such as Tandem Connect) that can identify 'yes/no' values and transform the data to a 1 or 0 before it sends to tandem.  What platform/protocol are you currently using to get data to your Tandem Streams?

[l.bell5H8JW]

Hi Derek,

We are using Disruptive Technologies and had a quick call to get their thoughts but they just generate a 'Occupied/ Not occupied' text for motion/ occupancy sensors and 'date/ time' for a touch/ push button sensor. They did say we could use a third party to convert. It has been a steep learning curve for us the last couple of days getting heads around most of Tandem so any help on any tutorials for the Tandem Connect would be appreciated!

[derek_milz]

Sounds good.  We actually just had a few customers just do the same integration with Tandem Connect and disruptive technologies.  If you could register for Tandem Connect here: https://intandem.autodesk.com/tandem-connect-beta/ 

Once you're registered (and have access), please reply back to this thread and I'll assist in getting that data to your tandem environment with a walkthrough.

[abiprayabim]

What type of parameter is used? to fill number 0 or 1

[abiprayabim]

Here is our project, we want the red or blue ones to be only on the patient's bed, not in the room. Is there a solution?

[abiprayabim]

I have several sensors such as temperature, humidity and also room capacity. Can I stream reading the three data with different APIs or different links provided by the sensor?

[derek_milz]

You will want to make the host of the connection the bed element. Also apply the same System Class in the Asset Properties, create a System, then in Heatmaps "Apply heatmaps to Systems."  That should allow you to change the bed colors.  Let us know if that works.

[Chad-Smith]

---

@abiprayabim wrote:

What type of parameter is used? to fill number 0 or 1

---

I thought I'd also give the suggested workaround a go.

But I am getting stuck with what I assume at this stage is a parameter mismatch, so I too would like to know which Tandem type of parameter we need to use.

My connection is accepting the data, but the property on the element (when selected) reports as null, and the connection (when selected) reports as *Varies*.

[derek_milz]

Hi Chad,

You'll want to setup your parameter as a datatype 'Number' as seen in the attached screenshot.  Also, when you do your conversions, make sure it's converting it to a numerical value 1 and not a string value "1".  I've done this before and ran into a similar issue - so just verify the value's that are coming in, don't have quotations enclosing the value.

Let me know if this helps!

Thanks,

Derek

[Chad-Smith]

Thanks for the parameter confirmation, and I have done exactly this.

I have since seen that all my elements are currently reading null, so it appears my issue is beyond just yes/no parameters. I'll raise this in a new thread.

[Chad-Smith]

The 0 / 1 workaround for this will be fine for the short-term, but it is definitely no permanent solution due to eroneous data in the charts.

The data threw me for a little while thinking it was a problem with my stream, until I realised it was just the chart calculating averages for the zoom level. Had me thinking momuntarily that the door was somehow only 1/3 open. 😃

[derek_milz]

Thanks for the response and visibility into this.  Yes, works for a short term solution and it's cool to see and play around with heatmaps for things like occupancy.  The team is working on supporting additional data types in the near future here for cleaner charts and additional functionality. Thanks Chad!

Derek

[Chad-Smith]

---

@derek_milz wrote:

You will want to make the host of the connection the bed element. Also apply the same System Class in the Asset Properties, create a System, then in Heatmaps "Apply heatmaps to Systems."  That should allow you to change the bed colors.  Let us know if that works.

---

This is the final step for me to getting this working, but I have faced two blockers.

1. The System Classes appear to be fixed values for traditional systems. Am I correct that these cannot currently be expanded to cover IoT classes?
2. After applying a System Class such as 'Other', assigning the connection to a Host, and then with the heatmap on using the "Apply heatmaps to Systems", I think my issue over in this thread might be preventing the systems heatmap from working. I'm assuming the systems heatmap is reading data from the host rather than the connection.

[derek_milz]

See the screenshots attached I did on a quick test:

• Assign a connection to a Host.
• Assigned System Class to 'Other'
• Created a Systems Group called 'Test' which includes just the System Elements from 'Other'
• Enable 'Apply heatmaps to Systems'
• Color of my roof drain changes based on the value
• I've got the roof drain selected and not the connection/pin in my screenshot which is why you see the null values.  When I select the pin, you do see the values as expected.

Derek