Use Filter to change ranges in chart properties
I have a situation where the consumer would like to use the face gauge to see their performance. The consumer of the card has several clients with different goals, and would like to be able to change clients using filters. I have not been able to find a way to have the minimum and maximum values of the chart properties change based on the client that has been selected with filters, but maybe I don't know how to articulate that in a search of topics.
Is there a way to have the maximum and minimum values in the range properties change, based on a selection that is made using filters?
Ex. Client A has goal of 80%, but client B has a goal of 85%, so the minimum values of the Green Range would have to change for client A and client B.
Comments
-
I am not aware of a way to dyanmically change chart min/maxes.
I have seen what you are describing accomplished in other gauges by normalizing pct to goal as an "out of 100%".
Only catch, you would need to have the "Actual" and the "Goal" in your dataset to dynamically calculate them.
Client A - Actual 72%
Client A - Goal 80%
Client A - "out of 100%" would be 90% to goal (smiley face!)
Client B - Actual 51%
Client B - Goal 85%
Client B - "out of 100%" would be 60% to goal (frowney face!)
Domo Consultant
**Say "Thanks" by clicking the "heart" in the post that helped you.
**Please mark the post that solves your problem by clicking on "Accept as Solution"0
Categories
- 10.7K All Categories
- 1 APAC User Group
- 12 Welcome
- 36 Domo News
- 9.6K Using Domo
- 1.9K Dataflows
- 2.4K Card Building
- 2.2K Ideas Exchange
- 1.2K Connectors
- 339 Workbench
- 252 Domo Best Practices
- 11 Domo Certification
- 461 Domo Developer
- 47 Domo Everywhere
- 101 Apps
- 705 New to Domo
- 84 Dojo
- Domopalooza
- 1.1K 日本支部
- 4 道場-日本支部へようこそ
- 23 お知らせ
- 63 Kowaza
- 297 仲間に相談
- 649 ひらめき共有