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
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...
Hi,
It's a side by side bar chart.
"on change of"
table.product_type
@currentprevious
under show value - count of table.id
the formula @currentprevious is :
if {TABLE1.STARTDATE}>={?Start Date}
and {TABLE1.STARTDATE}<={?Start Date}+6 then "Current Week"
else
if...
Hi all,
I've created a side by side bar chart which I've plotted the count of records for this week against the previous week.
My data:
Current Week Previous Week
AA 11 4
BB 5 5
CC 6 1
DD...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.