Forum Discussion

Rotemshan's avatar
Rotemshan
Helper 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
  • v-kkf-msft's avatar
    v-kkf-msft
    4 years ago

    Hi Rotemshan ,

     

    Please try the Tachometer visual and create the measures:

     

    Range2Start_0-6 = MAX ( 'Response_table APAC'[0-6] )
    Range3Start_0-8 = [Range2Start_0-6] + MAX ( 'Response_table APAC'[7-8] )
    TotalValue_0-10 = MAX ( 'Response_table APAC'[0-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
    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

     

     

     

  • v-kkf-msft's avatar
    v-kkf-msft
    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

v-kkf-msft's avatar
v-kkf-msft
Community 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
Helper 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
    Community 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