topic Re: Filter in App Development

Filter

Anonymous — Fri, 08 Jan 2016 18:02:48 GMT

Please help me in this scenario

I have “CreatedDate” column in the data set i.e. 2014-02-04 09:40:00.000000, 2014-02-04 09:50:00.000000, 2014-02-04

16:40:00.000000 and so on. I want to filter in the CreatedDate > 2015-01-01 in the script

Please help

Thanks

Deepanshu Chamoli

Re: Filter

Gysbert_Wassenaar — Fri, 08 Jan 2016 18:59:58 GMT

In general you use a WHERE clause to filter data when loading data in a new table:

MyTable

LOAD

FieldA,

FieldB,

CreatedDate,

...other fields

FROM

MySource

WHERE

CreatedDate > makedate(2015)

;

Whether that works or not depends on the contents of the CreatedDate field. If it contains text strings then it won't work. If it contains date values (i.e. numbers) then it will work.

Re: Filter

Anonymous — Sat, 09 Jan 2016 06:55:41 GMT

Thanks a lot for reply

The date is in number values. Please find the attached sanpshot.

The Date is in date time format which includes the data from 2010 to 2015.

I have used the MONTHNAME("DATE") function to convert it in to the Months.

Question is I want to filter the dates greater than 2015 in the table only. If I used in the script it leads to filter out in every chart and table

Please let me know if it is making sense

Thanks

Deepanshu

Re: Filter

Gysbert_Wassenaar — Sat, 09 Jan 2016 17:26:22 GMT

First create a bookmark for the selection of the dates or months that you want to see in the chart. Then change the expressions in your chart to make use of the bookmark. For example Sum(Amount) becomes Sum({BookMarkNameHere}Amount). Replace BookMarkNameHere with the name of the bookmark you created.