Forum Discussion

sawn's avatar
sawn
Frequent Visitor
4 years ago

Gauge with dynamic target

Hello, kindly assist in showing how to create a dynamic gauge target based on a slicer. I have data on New water points to be constructed per State as well as the number of water points to be rehabilitated per state. I would like to show the achievement of each based on the target provided when the new or rehabilitated slicer is selected and not to show the total for both as the target.

 

State

New Water Points

Rehabilitated Water Points

A

7

3

 

B

30

10

 

C

8

2

 
    

 

 

I would want the target (currently showing 60) to change based on the slicer selected whether new or rehabilitated

 

Thank you

Need Help

2 Replies

  • v-zhangti's avatar
    v-zhangti
    Icon for Community Support rankCommunity Support
    4 years ago

    Hi, sawn 

     

    You may need to provide more details. Can you provide photos of the source data? How was the number of sites identified calculated? Where did the 26 in the figure come from? If you can, please give an example and let me know what you expect the output to be. I look forward to your response.

     

    Best Regards,

    Community Support Team _Charlotte

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.