Forum Discussion

Rotemshan's avatar
Rotemshan
Icon for Helper I rankHelper I
4 years ago
Solved

Create a gauge

I'm trying to build a Gauge, I managed to divide the data per the requested  The gauge shows rank divided as followed: 0-6 - Red 7-8 - Amber 9-10 - Green   I managed to create the following gr...
Need Help
Rotemshan's avatar
Rotemshan
Icon for Helper I rankHelper I
4 years ago

Hi v-kkf-msft 

I did exactly as you suggested, but, for some reason the counting is incorrect 

 

 

v-kkf-msft's avatar
v-kkf-msft
Icon for Community Support rankCommunity Support
4 years ago

Hi Rotemshan ,

 

In my data, [0-6], [7-8], [9-10], [0-10] are the columns in the table (and each row is duplicate value), so I calculated the maximum value of these columns. 

 

 

How are your Detractor, Passive and Promoter calculated? Are they from three separate columns or one measure?

 

 

Best Regards,
Winniz

  • Rotemshan's avatar
    Rotemshan
    Icon for Helper I rankHelper I
    4 years ago

    Hello v-kkf-msft 

    as I presented in the first post, 

    I created a new table and I'm using the following formula (I'm not sure this is the recommended way to do it )

    then I'm getting the following as fields available for me 

    which creates the following table 

     

     

     

    Response_table APAC =
    SUMMARIZE (
    Merge1,
    Merge1[Response_Details.Likely to Recommend NPS.1],
    "0-6", CALCULATE (
    COUNT (Merge1[Response_Details.Likely to Recommend NPS.1] ),
     
    Merge1[Response_Details.Likely to Recommend NPS.1] >= 0
    && Merge1[Response_Details.Likely to Recommend NPS.1] <= 6
    && Merge1[Account Region]="APAC"
    )
    ,
    "7-8", CALCULATE (
    COUNT ( Merge1[Response_Details.Likely to Recommend NPS.1] ),
     
    Merge1[Response_Details.Likely to Recommend NPS.1] > 6
    && Merge1[Response_Details.Likely to Recommend NPS.1] <= 8
    && Merge1[Account Region]="APAC"
    )
    ,
    "9-10", CALCULATE (
    COUNT ( Merge1[Response_Details.Likely to Recommend NPS.1] ),
     
    Merge1[Response_Details.Likely to Recommend NPS.1] > 8
    && Merge1[Response_Details.Likely to Recommend NPS.1] <= 10
    && Merge1[Account Region]="APAC"
    )
    ,
    "0-10", CALCULATE (
    COUNT ( Merge1[Response_Details.Likely to Recommend NPS.1] ),
     
    Merge1[Response_Details.Likely to Recommend NPS.1] >= 0
    && Merge1[Response_Details.Likely to Recommend NPS.1] <= 10
    && Merge1[Account Region]="APAC"
    )
    )
    • v-kkf-msft's avatar
      v-kkf-msft
      Icon for Community Support rankCommunity Support
      4 years ago

      Hi Rotemshan ,

       

      Please try the following measures:

       

      Range2Start_0-6 = SUM ( 'Response_table APAC'[0-6] )
      Range3Start_0-8 = [Range2Start_0-6] + SUM ( 'Response_table APAC'[7-8] )
      TotalValue_0-10 = [Range3Start_0-8] + SUM ( 'Response_table APAC'[9-10] )

       

      If the problem is still not resolved, please provide detailed error information or the expected result you expect. Let me know immediately, looking forward to your reply.
      Best Regards,
      Winniz