EXp.Help

[#1]

i m using sum({<month={$(cmonth)}>}visit) to show visit in particular month in bar chart.

it is showng all visit of month i have category in visits like full,half, quarter.

when i select full ,half and quarter from selection box i m getting value of that category visit

1)but i want to display name of category on chart what ever i have select in list box.

2)is there any way to that i get only category wise visit by adding somthing in above expression.

3)how to calcutale aggr by visit category using above expression.

[jagan]

Hi,

Try using Concat().

Regards,

Jagan.

[sivarajs]

use can aggregate like sum({<month={$(cmonth)}>} if(aggr(visit,category),visit)

use getfieldselections(Category) to get particular category