Forum Discussion

IPGeorgiev's avatar
IPGeorgiev
Icon for Helper III rankHelper III
5 years ago

Bucket via measure to column chart

Hi all,   I have a CSAT% which is calculated as follows = postive reponses/positive+negative. Then for each employee we have a specific CSAT% and I wanted to do a bucketing with this:   ...
Need Help
Ashish_Mathur's avatar
Ashish_Mathur
Icon for Super User rankSuper User
5 years ago

You are welcome.  Thank you for your kind words.  I am not clear about your new requirement.  Show me the exact result you want to see.

Also, if my previous reply helped, please mark that as Answer.

IPGeorgiev's avatar
IPGeorgiev
Icon for Helper III rankHelper III
5 years ago

Hi Ashish_Mathur ,

 

many thanks for the response!

Here an updated pbix file. - https://drive.google.com/file/d/1LzEwlt7jEhGeZtZqsjlvpE-cKGj5-u5M/view?usp=sharing 


To the CSAT table I have added a new column called channel(communication channel). I have also added a new table called targets.

What I want is to have the same visual  - instead of Week we should use TIme Month and the columns should show two groups and the respective amount of agents belonging to each group.

 

Those above the target and those below the target. Meaning that each bucket will calculated  the count of employees:

with CSAT for the respective MONTH which are above the TARGET for the selected CHANNEL and MONTH - meaning that it should find the correct target value from the target table based on Channel and Month .

 

Hope this is clearer now.

 

Many, many thanks in advance!!

 

  • Ashish_Mathur's avatar
    Ashish_Mathur
    Icon for Super User rankSuper User
    5 years ago

    Hi,

    I still do not understand.  Based on the data that you have shared, show the exact result you are expecting in a simple Table.

    • IPGeorgiev's avatar
      IPGeorgiev
      Icon for Helper III rankHelper III
      5 years ago

      HI Ashish_Mathur , apologize for not making this clear.

       

      I have prepared an exel file which shows the output I am looking for - I have made some tweaks to the data (sheet test) where I have added Channel and Month is not not just Feb but also March. 

       

      In the output sheet you can see what I am aiming for - "desired final ouput"

       

      Here a link - https://drive.google.com/file/d/1F-0VTpOGwEokUKFf9HQ7caCzNdvZW2CV/view?usp=sharing

       

      Many thanks in advance!

       

      Best regards,
      Ivan

      • Ashish_Mathur's avatar
        Ashish_Mathur
        Icon for Super User rankSuper User
        5 years ago

        Hi,

        In the Target worksheet, what is the usage of Target 1 and Overall 1?  Which one is relevant for our calculations?