Pie chart

[Anonymous]

Hi,

  I have created 2 pie chars inflight and completed. I have created two listbox showing weekending dates of the closed and start dates.

when I select a weekenddate in closed date the inflight pie chart must display the usercount which are in progress at that week.

I have attached the qvw file .

please help me solve this

[tresesco]

Select 'In_progress' status, you would see all closed date goes greyed out, that means the is no 'In Progress' users for closed dates in your sample data.

[Anonymous]

sorry..

I will attach another qvw showing weekend dates in list box.

in the closed dates weekending there is surely a startdate for in progress.

bt the data is not displaying

I want inprogress to show value irrespective of the date field selected

[tresesco]

Dhivya P wrote:

.... irrespective of the date field selected

Do you mean it would be same output when you select any date field as when no date is selected?

[Anonymous]

Hi Dhivya,

Find the attachment. Let me know if it is working for you

-Jai

[Anonymous]

when the closed date is selected the inprogress should show me which all user count are Inprogress at that time...

if this is not possible I atleast want to show the inprogress chart not affected on any closed date selection

I want to show atleast one of this..

[tresesco]

It's not about possibility here. Your data set doesn't have such records. However, if the second option you can go with you can bypass the selection in closed dt field using set like:

Count({$< [Closed Dt], STATUS={'IN-Progress'}>}DISTINCT [User-Story#])

[Anonymous]

thank you:)

this is one scenario what I wanted

I want to know if there is any possibility to show in progress chart only the user count records which have starting dates for selected closing date

[Anonymous]

thank you:)

[Anonymous]

Hi ,

  Can you lil bit elaborate about it.If possible

-Jai