distinct sum for ID column is not working

[reddy]

Hi 

                                        ID           STATUS                           UPDATED_DATE     ASSIGNED

                                        1           INPROGRESS                    04-FEB-2018           1

                                        1           ONHOLD                          05-FEB-2018           1

                                        2           INPROGRESS                    06-FEB-2018           1

when i taking sum(assigned) column it should be  2 for date range between 4feb to 5feb. but in chart the sum was 3. id 1 is hsowing for 1st week and it also showing for 2nd week. But Iam expecting it should take sum for only max date of each id. Ihave date range slicer also. I taking sunday as week end date.  Due weelky wise chart in each week it taking distinct sum. But i need sum for only max date of id. Here 1st feb is 4th week and 5th feb is second week in chart.

[reddy]

[SivaMani]

Could please share the chart?

[reddy]

[Anonymous]

@reddy,

How do you calculate the three different types of tickets? Could you please post expected result based on the sample data you have post?


Regards,
Lydia

[reddy]

                                        ID               STATUS                  UPDATED_DATE     ASSIGNED

                                        1           INPROGRESS                    04-FEB-2018           1

                                        1           ONHOLD                          05-FEB-2018           1

                                        2           INPROGRESS                    06-FEB-2018           1

In chart 4th feb is first week and 11th feb is next week, I had a slicer filter of daterange. In date range i selected between 4th and 6th feb. Then count of tickets should be 2 for maximum updated date of each ticket. but for me it showing 3 count. for 1st week it showing Id 1 and next week also it showing ID 1 count. But I needed only one count for each ID based on max uopadted date

[reddy]

[Anonymous]

@reddy,

The image you post is broken. Could you please re-upload the image?

Regards,
Lydia

[reddy]

I'm unable to add image