Tall Order to Fill - Graphing by dynamic prompt: yr, mo , qt

building reports webintelligence
1

Hi

I dont know if this is possible but I would like to create a report in which the user can enter a date range for one prompt then how to graph it on the second prompt

For example…
Data set : number of cars sold, sold date

The user would first enter the date range - cars sold from Jan 1 - May 30
Then on the second prompt they would pick from a drop list graph by quarter, month, year, month and year

On the graph the X axis label would dynamically change based on what the user picked in the second prompt: quarter, mo, year, mo and year

Thanks in advance

bobboard (BOB member since 2009-03-04)

2

Can this also be accomplished through drill downs. For example a drill down into quarter, month, year at the top and that could update the X axis. That could be another way of doing it other than using a prompt

I havent been able to get this to work yet.

Any ideas

Thanks … any help is really appreciated!

bobboard (BOB member since 2009-03-04)

3

I’m not sure how to do this, but how about just creating all 4 graphs, and only prompting users of the date range they would like to see?

jmfuller (BOB member since 2010-02-16)

4

One solution is to create each version of the chart on your report.

First make sure you’re retrieving, somehow, the user’s response that will contain the second prompt’s value. You can accomplish this several ways - one of which is to create a dummy table with column “Graph Type” and values “BAR_QUARTER”,“BAR_MONTH” etc and bring it into your report as a second query with just this object for which the user’s prompted to select a value.

Now align them to the same x,y coordinates on your report as well as same chart dimensions.

Create a new dimension variable on your report called “Graph Toggle” and define it as:


=If([Graph Type]="BAR_QUARTER") Then "Show_BAR_QUARTER" ElseIF ([Graph Type]="BAR_MONTH") Then "Show_BAR_MONTH"

Now, select each chart individually, and each time, add a filter condition using the Graph Toggle object and set it to “Equal to” and choose “Show_BAR_XXXXX”. For example, on the BAR_MONTH chart, you will add the Graph Toggle object as a condition and set it “Equal to Show_BAR_MONTH”. So, when the user’s response is BAR_MONTH then this report is displayed while the other three are hidden.

Good luck

Atul Chowdhury (BOB member since 2003-07-07)

5

Thank you jmfuller and Atul! Good ideas… Ill see how far I can get

bobboard (BOB member since 2009-03-04)