Charting on a formula

[civiram]

Hi,

I would like to create a chart based on formula. So what I wanted to do is to have a bar chart, each bar will correspond to a formula. The values for the x-axis would be something like " < 1 month", "< 3 months", "< 6 months">. The values for the y-axis would be the record count.

I created a formula for the "< 1 month"

if {Table1.startdate} in currentdate to (currentdate) - 30 then {Table1.ID} else {@null}

@null is a formual with nothing on it. This is taught to me by lbass. Thanks lbass.

@< 3 Months
if {Table1.startdate} in currentdate to (currentdate) - 90 then {Table1.ID} else {@null}

These formulas will be my show values in the chart expert. I'm not sure how I will get to show the values "< 1 month", "< 3 months" in the x-axis.

Can you please help.

thanks.

 

[civiram]

Sorry some typos:

the formula @< 1 Month should be

f {Table1.startdate} in (currentdate) - 30 to currentdate then {Table1.ID} else {@null}

@< 3 Months
if {Table1.startdate} in (currentdate) - 90 to currentdate then {Table1.ID} else {@null}

thanks again

 

[lbass]

I don't recall why I suggested that approach, but I think you would have to add the labels manually in text boxes in this case. You could check show "data label" in the chart expert, but this will result in "count of {@formulaname}".

-LB