Forum Discussion

imy's avatar
imy
Helper I
6 years ago

Progress charts

Good evening,

 

I am trying to produce a chart that shows the progress in data for example, today i have 2 deted items, 3 to be deleted and 5 NOT to delete. I need to check periodically (lets say every week) and show the progress on the same items (or even more categories if they exist) by date. Is this possible?

 

Many thanks!

 

Need Help

3 Replies

    • imy's avatar
      imy
      Helper I
      6 years ago

      Dear parry2k,

       

      I have a column with 4 different categories : DELETE, YES, NO, Set for deletion and some blanks (wich I need to include). I need to represent this in a bar chart (probably clustered colums chart). This is simple. However, we do weekly check on this results and we need to represent how this 4 categories change through time. For example:

      Week 1: Deleted 35, YES 50, NO, 100, Blank 350 = TOTAL: 535

      Week 2: Deleted 100, YES 100, NO, 100, Blank 200 = TOTAL: 535

      And so on.

      Is this possible?

      I hope my question is clearer now.

       

      Regards,

      Imy

       

       

       

       

       

       

       

      • v-juanli-msft's avatar
        v-juanli-msft
        Community Support
        6 years ago

        Hi imy 

        Assume you have tables

        Create a calculated column

         

        Column cate = IF([cate]=BLANK(),"Blank",[cate])

         

        Create measures

         

        count = CALCULATE(COUNT(Sheet3[id]),FILTER(ALLSELECTED(Sheet3),Sheet3[Column cate]=MAX(Sheet3[Column cate])))

current week = CALCULATE([count],FILTER(Sheet3,WEEKNUM(Sheet3[date],2)=WEEKNUM(TODAY(),2)))

Last week = CALCULATE([count],FILTER(Sheet3,DATEDIFF(Sheet3[date],TODAY(),WEEK)=1))

change every week = [current week]-[Last week]

         

        Best Regards
        Maggie
        Community Support Team _ Maggie Li
        If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.