topic Re: Applying filters on a chart in web report studio in SAS Web Report Studio

Applying filters on a chart in web report studio

jb9977 — Tue, 29 Aug 2017 19:07:04 GMT

Hi Everyone,

I want to know if we can apply two filters on a single chart in web report studio. for example if i am creating a bar chart based on number of sales and total revenue of sales. can i apply filters so that my graph shows number of sales>50 and revene of sales >50000?

Thanks,

jay

Re: Applying filters on a chart in web report studio

FredrikE — Wed, 30 Aug 2017 09:37:03 GMT

What if you create the the combined filter in the information map and then use it as a section filter in WRS?

//Fredrik

Re: Applying filters on a chart in web report studio

jb9977 — Wed, 30 Aug 2017 14:37:32 GMT

Hi Fredrik,
There are other charts that need the entire data.

Thanks,
Jay

Re: Applying filters on a chart in web report studio

FredrikE — Wed, 30 Aug 2017 14:49:36 GMT

Hmm, then I would split them into different sections, with different section filters 🙂

I don't know any other way to solve this :0 since you can only have one filter on the objects at the samt time...

//Fredrik

Re: Applying filters on a chart in web report studio

Madelyn_SAS — Wed, 30 Aug 2017 15:21:51 GMT

You could put a category filter and a measure filter on the same bar chart, but you cannot create a combination filter for multiple measures from the Filter & Rank dialog box.

Applied filters: Country equal to CANADA AND Actual Sales greater than $245,000.00