Show only data which changed today

[#1]

Hello,

I have a data set like this :

Date	Brands
07-07-2014	Lenovo
07-07-2014	Amazon
07-07-2014	Samsung
07-07-2014	Whirlpool
08-07-2014	Lenovo
08-07-2014	Amazon
08-07-2014	Samsung
08-07-2014	Whirlpool
08-07-2014	Apple

I want to have a list which shows only the brands which are newly added today (08-07-2014).

The result I expected is :

Brands
Apple

Should I use set analysis or can I use another function ?

I tried above(), but I only get the 'brand' above the one that I selected and not the brand from yesterday.

Thank you.

[sasikanth · Accepted solution]

hi

try some thing like below

Aggr(if(date=Today(),brand),brand)

[alexandros17]

Try this formula as dimension in a chart (and add an expression with value = 1)

If(min(date)=max(date) and  date=today(), Brands, Null())

let me know

[#4]

Thank you, it works !