Discussions
Categories
Choose a Product
THRUST SERVICES
CORE APPS
CE PRODUCTS
...
Quick Links
POPULAR
HELPFUL TIPS
Groups
My Links
FOR SIGNED IN MEMBERS:
Back to website
Home
Designing Analytics Reports
Formatting display value for Dynamic Filter Parameter
Migrateduser
Hi,
I'm designing a report using dynamic filter parameters. I would like to include the parameter values in an end note so the user knows what values they selected if they decide to print/pdf the report.
The issue I'm having is that the params["parameterName"].value function provides very technical results that my not very savvy clients will understand. Is there any way to "translate" the values so that the parameter results look like normal English, instead of tech-speak? I can't think of anything - since the operator changes, it's hard to parse the values into pieces that I could engineer.
A few examples (with multiple types of operators):
Data Element: if(params["param_Disease"].value=="") {"All Diseases"} else("Diseases restricted to: "+params["param_Disease"].value)
Result: Diseases restricted to: ([DISEASE] = "Disease1")
Desired Result: Diseases restricted to: Disease1
Data Element: if(params["param_State"].value=="") {"All States"} else("States restricted to: "+params["param_State"].value)
Result: States restricted to: IN([STATE],"IL","IN")
Desired Result: States restricted to: "IL","IN"
Data Element: if(params["param_Date"].value=="") {"All Periods"} else("Date restricted to: "+params["param_Date"].value)
Result: Date restricted to: BETWEEN([DATE_FIELD],"2000-01-01 00:00:00.000-0500","2012-07-24 00:00:00.000-0400")
Desired Result: Date restricted to: between 1/1/2000 and 7/24/2012
Find more posts tagged with
Comments
There are no comments yet