Search results for query: *

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...

Your solution worked! Thank you very much.

hi, any idea? or if this is not possible, what are other alternatives that I can use to achieve the same objective? thanks.

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...