Not updating dashboard with values selected in two selectors

[Former Member]

I built a dashboard with Date, Total Calls, Group

For Date, I inserted Calendar component. Based on the Date selected from Calendar, my dashboard is diplaying data for each group

Now I need users to select Group as well from the list.

I developed a query including Group inlist prompt in Qaaws along with Date inlist prompt

After specifying input, output values mapping to Excel sheet cells for Refresh button I choose refresh on load

Now the date input is in Cell E6 where as group input is in E6-E12

The query usage is defined to load on triggering cells from E6-E12

AFter that also when I refresh dashboard it is still loading data based on the selected date and the 1st group appeared in the list box of Group

Please let me know whether it can be possible to select values from two selectors and display results in Xcelsius 2008 ??

If so, please explain me with an example.

I have been researching on this since last one week. Still couldn't find any answer

[Former Member]

I'm not sure if this is the solution to your question, but it seems you are saying your query triggers on cells E6-E12 (unless you have multiple queries).

Trigger Cell binding will only actually trigger on the first cell reference, even if you bind to a range.

So if you bind to E6:E12, only E6 will actually cause a trigger. The other cells will be ignored by the Trigger Cell field, even though the reference E6:E12 is displayed.

<br>

Javier

[Former Member]

I created three queries in Qaaws

1. Query to get Date, Total, Group into the display - Two prompts- one on Date, one on Group

2. Created one query only on Date - no prompts

3. Created one query only on Group - no prompts

Imported model to Xcelsius

2. Query out put cell ponting to E6

3. Query output pointing to Cells E7 - E12 as we have 6 Group values as of now

1. Query input Date prompt points to E6

Group prompt points to E7-E12

Usage options: Refresh on load, trigger cells E6-E12

Added Refresh button:

Load options: Refresh on Load

Even the Date prompt is not working. So I am using Calendar component whose destination pointed to E6

So dashboard is working now only for the date

I need to update dashboard everyday for a selected group

How to achieve this ??

[Former Member]

Sounds very interconnected with lots of coupling.

Usage options: Refresh on load, trigger cells E6-E12

Added Refresh button:

Load options: Refresh on Load

Without seeing your model, I'm guessing you'll have to create a conditional Excel formulas (i.e. IF) that references E6:E12, then Connection Refresh buttons (Web Connectivity folder) with Triggers bound to the conditional formula cell.

If you post your model, someone may be able to give more specific advice.

[Former Member]

I added refresh button from components to refresh dashboard.The refresh options are set to refresh on Triggering cell etc

Let me know how to add my moel here ?? I don't see any attachment options