Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have an expression in a bar chart that displays a count of customers. I would like create a straight table that allows me to see the detail behind the expression. For example, 201607 there are 49,998 customers. How can I create a listbox to capture those individuals.
=If(STARTDATE_YYYYMM >= Max(TOTAL STARTDATE_YYYYMM, 6), Below(RangeSum(Below(Count({<ENROLLMENT_STATUS = {'Open'}>}ID), 0, NoOfRows() - RowNo() + 1))) + Count(ID))
Try this expression:
=Aggr(If(
RangeSum(
Count({<Status = {'Open'}>}ID)
+
Count({<STARTDATE_YYYYMM = {$(=Max(STARTDATE_YYYYMM))}>} ID)) > 0, ID), ID)
Assuming I can create a list box expression. I just copied and pasted my chart expression but I don't see results.
Can you provide a sample to look at?
Do you want to display the numbers in the table as a list like something below?
Not sure if this is what you are looking at
Hi Mrjohn,
Create a STable in that ENROLLMENT_STATUS ,Customer ID,Custermer Name...etc and your Expression
(=If(STARTDATE_YYYYMM >= Max(TOTAL STARTDATE_YYYYMM, 6), Below(RangeSum(Below(Count({<ENROLLMENT_STATUS = {'Open'}>}ID), 0, NoOfRows() - RowNo() + 1))) + Count(ID)))
i hope it will gives the all 49,998 customers individually.
else
create Straight table with customer details fields,your expression,2nd Expression as =1,List box (ENROLLMENT_STATUS ) select the Open option.
it will gives your result.
See attached. I would like to see the details behind the numbers on the chart. I created a straight chart and added my details but when I select the number in the chart my straight table does not match.
Is the issue still open? I saw it getting closed in the morning?
It was accidentally mark closed but is still open as my issues is not resolved.
Try this expression:
=Aggr(If(
RangeSum(
Count({<Status = {'Open'}>}ID)
+
Count({<STARTDATE_YYYYMM = {$(=Max(STARTDATE_YYYYMM))}>} ID)) > 0, ID), ID)