Hi,

I have a pretty simple table I am using with the following fields: Year, Month, Count of Incident, Rate of Incident, Incident_type, and Location.

I am trying to create a Guided report, where the user selects one or both metrics (Rate, Count) and then there are two dimensions (Location, and type), and across is the Year/Month.

I was able to successfully break out my dimensions/metrics. But when I run the report, it comes up to being quite a mess. For example, every column repeats itself (what the incident type is), I was thinking is there anyway to clean it up? For example, can you make the selection at the beginning to only show the incident type of "falls" (one of the possible values in the incident_type field), or select one of the units only and only display those?

My code is as follows:


TABLE FILE FACT_RISKPRO_RATES
PRINT
&METRICS.(AND(,)).METRICS.
&DIMENSIONS.(BY(,)).DIMENSIONS.
ACROSS LOWEST
&XTABS.(ACROSS(,)).XTABS.

This message has been edited. Last edited by: hfung1,

Add a WHERE clause.

See WF tutorial for Guided Reports:
Guided Reports part 1
Guided Reports part 2

Hi,

Thank you, the videos were very helpful!