Indicator source returns "0 records match condition", need help !

[e-shoppers]

I have been building PA dashboards for senior since early this year and have been creating most of the indicators we want.

There is one request form I want to create an indicator in which the "variable field1" contains a push down list of categories and "variable field2" contains the subcategories but I have no success so far, it always return "0 records match condition". And when I hit the update count icon, it returns "1631 records match condition" however it will return to 0 again when save.   Does anybody know why? Thanks a lot in advance.

 

[Dennis R]

Sounds like a glitch, probably a result of the filter running against a special-purpose related list [sc_item_option] instead of a normal field on the sc_req_item form.   Have you tried actually using the source in an indicator and see if it collects any record information?

[e-shoppers]

Hi Dennis, yes I tried that indicator but it does not return any record or scores, in fact there is no problem to collect the records in a report using the same condition so I believe they are related and such behavior is very unusual.

[Josh Cooper]

Just to clarify, are you trying to set up an indicator, like a count, but you ONLY want to count the one specific Category/Subcategory, and don't care about the rest?

Or are you trying to get a total count, with individual counts for each of the different options for Category/Subcategory?

You may be wanting a Breakdown source rather than an Indicator source.

[e-shoppers]

Hi Josh, I want to get a total count, with individual counts for each of the different options for Category/Subcategory as you said.   The specific purpose of this request form is to record simple enquiries from customers which don't require service from us. These enquiries are categorized and contained in two variables inside item_option_new instead of the normal fields in a sc_req_item form. The records can be retrieved through reporting but just not in PA indicators. For your suggestion of using Breakdown source, however the mapping cannot be done to the fact table sc_req_item because the variable is unable to relate.   How can I build such mapping relationship?