GitHub user dosubot[bot] added a comment to the discussion: bullet chart apache 
superset

<!-- Greeting -->
Hi @fifi1905! I'm [Dosu](https://go.dosu.dev/dosubot) and I’m helping the 
superset team.

<!-- Answer -->
In Superset's Bullet Chart, the Markers field is currently designed to accept 
only static numeric values—you can't reference a measure or metric directly in 
this field. This is a known limitation and has been discussed by other users as 
well: both the achievement (measure) and the target (marker) should ideally be 
dynamic, but at the moment, only the measure can be set dynamically, while the 
marker (target) must be entered manually as a number. There is no UI option to 
select a metric or column for Markers, and typing a measure name will not work. 
You can see more about this limitation in this discussion: [Superset Discussion 
#28647](https://github.com/apache/superset/discussions/28647).

If your targets are dynamic, a common workaround is to preprocess your data 
outside Superset (for example, in your database or ETL pipeline) so that your 
achievement and target are both available as columns or calculated values. 
Then, you can use the achievement as the measure and manually enter the target 
value in the Markers field.

If you need fully dynamic targets, you may want to follow Superset updates or 
feature requests for future support, as this is a frequently requested 
enhancement.


<!-- Dosu Comment Footer -->
*To reply, just mention [@dosu](https://go.dosu.dev/dosubot).*

---
<sup>How did I do? 
[Good](https://app.dosu.dev/response-feedback/97667a67-af79-4312-9a42-8b5fb8431381?feedback_type=great_response)
 | 
[Irrelevant](https://app.dosu.dev/response-feedback/97667a67-af79-4312-9a42-8b5fb8431381?feedback_type=irrelevant_answer)
 | 
[Incorrect](https://app.dosu.dev/response-feedback/97667a67-af79-4312-9a42-8b5fb8431381?feedback_type=incorrect_sources)
 | 
[Verbose](https://app.dosu.dev/response-feedback/97667a67-af79-4312-9a42-8b5fb8431381?feedback_type=too_verbose)
 | 
[Hallucination](https://app.dosu.dev/response-feedback/97667a67-af79-4312-9a42-8b5fb8431381?feedback_type=hallucination)
 | [Report 
🐛](https://app.dosu.dev/response-feedback/97667a67-af79-4312-9a42-8b5fb8431381?feedback_type=bug_report)
 | 
[Other](https://app.dosu.dev/response-feedback/97667a67-af79-4312-9a42-8b5fb8431381?feedback_type=other)</sup>

[![Chat with 
Dosu](https://dosu.dev/dosu-chat-badge.svg)](https://app.dosu.dev/a28d3c7e-a9d3-459e-9fb6-3a6f9ff4f357/ask?utm_source=github)&nbsp;[![Open
 in 
Cursor](https://dosu.dev/dosu-in-cursor.svg)](https://cursor.com/link/prompt?text=In%20Superset%27s%20Bullet%20Chart%2C%20the%20Markers%20field%20is%20currently%20designed%20to%20accept%20only%20static%20numeric%20values%E2%80%94you%20can%27t%20reference%20a%20measure%20or%20metric%20directly%20in%20this%20field.%20This%20is%20a%20known%20limitation%20and%20has%20been%20discussed%20by%20other%20users%20as%20well%3A%20both%20the%20achievement%20%28measure%29%20and%20the%20target%20%28marker%29%20should%20ideally%20be%20dynamic%2C%20but%20at%20the%20moment%2C%20only%20the%20measure%20can%20be%20set%20dynamically%2C%20while%20the%20marker%20%28target%29%20must%20be%20entered%20manually%20as%20a%20number.%20There%20is%20no%20UI%20option%20to%20select%20a%20metric%20or%20column%20for%20Markers%2C%20and%20typing%20a%20measure%20name%20wi
 
ll%20not%20work.%20You%20can%20see%20more%20about%20this%20limitation%20in%20this%20discussion%3A%20%5BSuperset%20Discussion%20%2328647%5D%28https%3A//github.com/apache/superset/discussions/28647%29.%0A%0AIf%20your%20targets%20are%20dynamic%2C%20a%20common%20workaround%20is%20to%20preprocess%20your%20data%20outside%20Superset%20%28for%20example%2C%20in%20your%20database%20or%20ETL%20pipeline%29%20so%20that%20your%20achievement%20and%20target%20are%20both%20available%20as%20columns%20or%20calculated%20values.%20Then%2C%20you%20can%20use%20the%20achievement%20as%20the%20measure%20and%20manually%20enter%20the%20target%20value%20in%20the%20Markers%20field.%0A%0AIf%20you%20need%20fully%20dynamic%20targets%2C%20you%20may%20want%20to%20follow%20Superset%20updates%20or%20feature%20requests%20for%20future%20support%2C%20as%20this%20is%20a%20frequently%20requested%20enhancement.)&nbsp;[![Join
 
Discord](https://img.shields.io/badge/join-5865F2?logo=discord&logoColor=white&label=)](https://go.do
 su.dev/discord-bot)&nbsp;[![Share on 
X](https://img.shields.io/badge/X-share-black)](https://twitter.com/intent/tweet?text=%40dosu_ai%20helped%20me%20solve%20this%20issue!&url=https%3A//github.com/apache/superset/discussions/36287)

GitHub link: 
https://github.com/apache/superset/discussions/36287#discussioncomment-15083611

----
This is an automatically sent email for [email protected].
To unsubscribe, please send an email to: 
[email protected]


---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]

Reply via email to