Simple Date Graph

[knightwriter]

Hi All,

Basic question here. I want to create a graph showing:

• medals won in 2015
• By month (x-axis)
• Count the medals per month

my fields available are:

• [Medal.Won/Lost Date]
• [Medal.Status]= 'Won'

I cannot get this expression as I need to use the Won/Lost date as both the InYear and month.

Appreciate any help

[sunny_talwar · Accepted solution]

May be this:

Dimension: MonthName([Medal.Won/Lost Date])

Expression: Count({<Year = {'2015'}, [Medal.Status] = {'Won'}>} [Medal.Status])

[knightwriter]

Thanks again sunindia, great stuff.