Forum Discussion

Martin74's avatar
Martin74
Helper I
6 years ago
Solved

Need help with parameter in SQL statement

Hi everybody,   I have a simple statement. In the statement below Search is the parameter I made. When I fill custom criteria the statement works fine. When I change the custom criteria it also wor...
Show and Tell
amitchandak's avatar
amitchandak
Super User
6 years ago

Create a measure like this and add it to table or matrix along with [PointName],[PointID],[PointSliceID],[UTCDateTime]

new ActualValue =
calculate(sum(RawAnalog[ActualValue]),RawAnalog[UTCDateTime] >= date(year(today())month(today())-1,day(today())),
		search("Search",RawAnalog[PointName] ,1,0)>0)

 

  • Martin74's avatar
    Martin74
    Helper I
    6 years ago

    Thanks for your reply, maybe I am not clear enough. The meaning is to import only the data that is needed, so search must contains some characters from Pointname. When search contains '%United States%' only pointnames with United States must be imported. All this in a template. When I only use the IP address as a parameter all works fine, by adding the second parameter (Search) it shows up by making a connection but doesn't do the job well.