Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Try the below expression.
count({<status = {'new'}>}number)
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
Try this
Count({<status = {'new'}>}number)
Regards
ASHFAQ
try like: Count({<status = {'new'}>}number)
Dimension:
MonthName(date)
Expression:
Count({$<status={'new'}>} number)
HI Ahmad,
Add Dimension Date ,and also Add Caliculated Dimension like if(Status='New',Status) and expression would Be Count(Number)
-Sateesh