Forum Discussion

NickzNickz's avatar
NickzNickz
Helper IV
2 years ago

Get total value for different status

In my dashboard, I use Visual Calendar by MAQ Software to show the status of planning, Advertisement, Selling and Closing as in the example below:

My problem is the status show the total of number for all status for the said date. 

Example #1  : 1 December 2023 (Friday). The actual # is 1 for Advertisement and 1 for Closing. (Total = 2)

Example #2  : 10 December 2023 (Sunday). The actual # is 1 for Planning, 1 for Advertisement, 2 for Selling and 1 for Closing. (Total = 5)

 

How can I achieve that .... 

 

Other Information :

In original table , I have multiple date column and other information. From there, duplicate the table and remove unnecesary column and remain only the date column. I use pivot table to consolidate multiple column date and become single date with different status.

Please let me know if need more information ...

 

Regards,

NickzNickz

 




 

 

Need Help

4 Replies

  • Deepak_'s avatar
    Deepak_
    Advocate I
    2 years ago

    Hi NickzNickz ,

    From what I can understand you want to count each status for a given date.
    So I have tried this out in Power BI.
    Data I am using : 

    Solution: 

    You can show the count of status to get the results you want.


    Let me know if this is correct.




     

    • NickzNickz's avatar
      NickzNickz
      Helper IV
      2 years ago

      Deepak_ ,

       

      The calendar visual I use requires the following information:

       

      Based on the sample given, I need to have a column and I cannot use measure. As sample above, I created column name Total # Tender  but as we can see the total for each status appear the same .... 

       

      Regards,

      NickzNickz