Search results matching tag 'filters'

Re: Reset buttons for filter boxes

manoj_lanser — Wed, 02 Jan 2013 11:02:03 GMT

Hi Wgreene, Drop Down is a property control not a usual filters that why they don't get reset with we click on Reset Filters.You cannot add 'all' values in drop down. Regards Manoj Singh

Re: Eliminating (All) option on radio button filter

manoj_lanser — Tue, 18 Dec 2012 05:18:03 GMT

Hi Chris, You cannot eliminate (All) Option from the filter panel . The workaround for this problem is you can change the existing filter type to Checkbox type. You cannot eliminate (All) option when using radio button Regards Manoj Singh

How to make Spotfire Webplayer reset filter on filter panel to default state

Rabindranath — Wed, 21 Nov 2012 09:32:49 GMT

Hi, I have some checkbox filtering in my filter panel, by default only the first item is selected. When users reset all filters in the Spotfire WebPlayer, they get all checkboxes selected (instead of selecting the default one). Is there any way to reset filters to their default state? I'm using Spotfire 3.3

range control (filter) in custom panel?

MattS — Fri, 09 Nov 2012 21:46:21 GMT

Is it possible to add a range control/filter to a custom panel? I need to create a custom control that extends the range control with some extra information. It would be great if I could get access to the range control that controls the range filter. It must be possible given that filters can be inserted into text areas. Any pointers would be appreciated.

Grouping filter parameters

AlisaB — Thu, 26 Jul 2012 16:56:35 GMT

Say that I have a basic filter on the side of my screen for "Month", and in it I have "Jan 2012" through "July 2012". I want to combine Jan - Mar 2012 into a grouped parameter called "Q1" and have THAT be displayed as the column instead of the 3 separate ones. How do I do that?

Thanks!

Re: Set filters to initial state (not reset)

Madelman — Fri, 06 Jul 2012 14:19:01 GMT

The easiest solution to this is to create a bookmark and make it public with those original settings.

Max

How to reset all visible filters in code

indy2005 — Wed, 23 May 2012 17:25:03 GMT

Hi,

I need to reset all "visible" filters via code, across all pages....so I can perform the action across all pages via a button on the cover page.

many thanks

New columns on filter panel

Joe — Tue, 01 May 2012 15:37:16 GMT

If I add a new data table, or a new column to an existing data table, those tables/columns are automatically added to filter panel, which is really annoying. Is there any way to turn off this "automatic add"?

Can someone assist - new to Spotfire and looking to create an "average min" expression

blevine — Tue, 03 Apr 2012 22:02:26 GMT

Any help would be greatly appreciated...

I have a dataset of people. Each person has different activities they may engage in and amount of calories they may burn. In a HIGHLY simplified state, it essentially looks something like this:

Participant	Time	Calories Burned	Activity
John	12pm	141	Running
John	1pm	210	Running
John	2pm	331	Running
John	3pm	223	Swimming
John	4pm	296	Swimming
John	5pm	95	Swimming
John	6pm	365	Swimming
Susan	12pm	232	Swimming
Susan	3pm	220	Running
Susan	4pm	185	Running
Lee	12pm	301	Running
Lee	1pm	314	Swimming
Lee	2pm	22	Running
Lee	3pm	384	Swimming
Lee	4pm	307	Running
Lee	5pm	468	Running
Lee	6pm	457	Running
Lee	7pm	200	Swimming
Avril	1pm	228	Swimming
Avril	2pm	469	Running
Avril	3pm	3	Running
Avril	4pm	455	Swimming

If I graphed this data in Spotfire with "Activity" on the horizontal axis and calories on the vertical axis (aggregating by min), I would see a value of 3 for running and 95 for swimming.

But, what I really want is the visual to be of the average minimum (the minimum per participant averaged) of people in this study.

The min for each participant averaged is 88 for running and 189 for swimming (see below):

	Min
	running	swimming
John	141	95
Susan	185	232
Lee	22	200
Avril	3	228


	running	swimming
Average Min	87.75	188.75

Is there a way to create an expression to plot this in Spotfire? CUrrently, if I choose min as an aggregation, it will just give me the min across all bins. I need to take the min per person and then average it.

My real dataset has 120 people, maybe 30 activities and 300 to 4000 rows per person.

Thanks in advance,

Brian

How to pass filter parameters into a stored procedure

indy2005 — Sat, 03 Mar 2012 06:02:07 GMT

Hi,

With a normal information link, I am assuming multiple selections in an on-demand parameter get turned into some kind of in clause at the database.

I need to allow multiple selections in a filter panel to be sent as a parameter to a procedure.

How does this work, or is there a script which can gather selections in a filter panel into a comma separated list, which then gets passed as a parameter...so the stored procedure can then parse the CSV into an in-clause?

We need to do this for a lot of our analysis, where we need to create filter panels which serve only as "application inputs" into the procedure where the logic is dealt with.

Regards