Set Anaylsis Question

[#1]

In the attached document in the tab "Service Ticket" I have a chart object titled "Service Ticket Records" and trying to determine what the correct Set Analysis to bring back all dates where "Status =2".

[nagaiank]

If you select the status of 2 in the  multibox, the table below shows all the records of interest. Is there anything else needed?

[#3]

I am trying to have the chart object "Service Ticket Records"  default to status 2 versus changing the status list box as users want to switch from tabs without the status alternating from different status.

[johnw]

It appears that all of your expressions can be dimensions instead.  Do that.  Then add new expression:

only({<Status*={'2'}>} Date)

On the presentation tab, hide that column.  Now, the way I set it up, it won't OVERRIDE the selected status.  So if someone selects status 1, nothing will display in the chart because status 2 has been excluded.  If you STILL want to display all the status 2 data in the chart, even when it isn't a possible value, then just remove the *.

[#5]

John,
I got that working, is there a way when you select the service ticket tab it shows all of the status 2 in the chart versus having to change the status list box to 2 in order for the rows to return in the chart.

[johnw · Accepted solution]

I don't understand.  The set analysis IS how you show all status 2 in the chart without having to change the status list box to 2, with or without the * depending on the exact requirement.  In your example, I think you've selected a date for which there is no status 2, so there is nothing to display.  Is that the problem?  Sorry, I guess I'm not not following.

[#7]

Sorry for the confusion.  When selecting the service ticket tab I am trying to get the chart to populate with all dates that have a status "2" without have to change the list boxes for status and all dates so the other tabs point of view don't change.

[johnw]

OK, so if someone selects status 1 or a specific date, you want to completely ignore that?  I guess you might want to ignore ALL selections?

only({1<Status={'2'}>} Date)