graph show date only for number with status=new

[Anonymous]

number   id      date              status

123       1      1/1/2015            new

123       2      2/1/2015           pending

124       8      12/12/2014         new

125       7      (blank)                pending

125       7      5/1/2015            new

125       7      8/1/2015             new

126       4      7/7/2015            pending

126       4      (blank)               new

need help to create graph that show date only for new. the graph must show the count of number according to date_month

[Anonymous]

Try the below expression.

count({<status = {'new'}>}number)

[krishna20]

Hi ahmad,

First of all bye-pass your date field like this.Date(Your_field,'DD-MM') as Date_Month

then, take it as a dimension.

Apply your expression

Count({<status={'new'}>}number)

Regards

Krishna

[ashfaq_haseeb]

Try this

Count({<status = {'new'}>}number)

Regards

ASHFAQ

[avinashelite]

try like: Count({<status = {'new'}>}number)

[MarcoWedel]

Dimension:

MonthName(date)

Expression:

Count({$<status={'new'}>} number)

[sat_tok52]

HI Ahmad,

Add Dimension Date ,and also Add Caliculated Dimension like if(Status='New',Status) and expression would Be Count(Number)

-Sateesh