Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
hello all,
i hv a sales table, with invoice date and is used as master calendar
member is in sales table to indicate the buyer
on the other hand, there is a member master, with join date inside
sales:
inv_date, inv_date_year, inv_month, member_id ...
member:
member_id, join_date, ..., sumcount
i want to count the # of new join member within a selected period (using inv_date)
but i cant count those member who join but make no purchase at all, even using set analysis
Sum(
{$<joint_date = { ' >=$(=Min(inv_date)) <=$(=Max(inv_date)) ' }>}
sumcount
)
is there no way for me to do the counting using the same data model?
thanks
As I read your request, you select a period in sales table field inv_date. This will associate only members in member table that have record in sales table, as long as you use the default state for your analysis. But what about using the set identifier 1?
Sum(
{1<joint_date = { ' >=$(=Min(inv_date)) <=$(=Max(inv_date)) ' }>}
sumcount
)
or disregarding the explicit selections on inv_date:
Sum(
{$<joint_date = { ' >=$(=Min(inv_date)) <=$(=Max(inv_date)) ' }, inv_date= >}
sumcount
)
As I read your request, you select a period in sales table field inv_date. This will associate only members in member table that have record in sales table, as long as you use the default state for your analysis. But what about using the set identifier 1?
Sum(
{1<joint_date = { ' >=$(=Min(inv_date)) <=$(=Max(inv_date)) ' }>}
sumcount
)
or disregarding the explicit selections on inv_date:
Sum(
{$<joint_date = { ' >=$(=Min(inv_date)) <=$(=Max(inv_date)) ' }, inv_date= >}
sumcount
)
hi
your answer is correct, but i forget to tell u that, my expression is a chart expression
the solution works perfectly in a text object expression
but will still be affected by dimensions if put inside a chart expression
in my case, my expression "count" is under dimension "inv_date"
so putting 1 as set identifier seems not working (member without sales still not shown under certain period)