We have managed to set up a streaming dataset that is driven via a Powershell script which pulls data from our SQLServer DB. Everything is working well apart from some really stange behaviour when trying to create measures, does anyone know if there are any known limitations when working in this way?
One measure we have tried is:
ALL ( RealTimeData[timestamp] ),
RealTimeData[timestamp] = MAX ( ( RealTimeData[timestamp] ) )
RealTimeData[timestamp] is a datetime field
This has worked in other reports but not with the streaming datset. We have also noticed that trying to use a top N filter also behaves strangely.
I have searched online but the documentation (that I have found) is not very clear