GitHub user dosubot[bot] added a comment to the discussion: pivot table can not modify value format
<!-- Greeting --> Hello @SettZhou! I'm [Dosu](https://dosu.dev), your friendly bot here to help you with bugs, questions, and becoming a contributor. I'm here while you wait for a human maintainer, so let's tackle this together! <!-- Answer --> The issue you're experiencing with the pivot table not applying the custom value format could be related to how Superset handles conflicts between the default d3format settings in the dataset configuration and the custom value formats specified in the pivot table. Unfortunately, I couldn't find specific information on how Superset resolves these conflicts. However, you can try the following workaround: 1. Check if there is an option to override the dataset's default d3format directly in the pivot table's settings. Sometimes, there might be a toggle or setting that allows you to prioritize the custom format over the default one. 2. If the above option is not available, consider modifying the dataset configuration temporarily to remove the default d3format for the metric `ReportedNCA` and see if the custom format in the pivot table then takes effect. These steps might help in applying the desired format. If the issue persists, it might require further investigation into the Superset codebase or configuration settings. This appears to be a tricky issue, @rusackas, your expertise would be greatly appreciated here. <!-- Dosu Comment Footer --> *To continue talking to [Dosu](https://dosu.dev), mention @dosu.* --- <sup>Help Dosu learn! Give it feedback: [Great Response](https://app.dosu.dev/response-feedback/9b213ab8-2937-4de4-9550-baaa905da921?feedback_type=great_response) | [Irrelevant Answer](https://app.dosu.dev/response-feedback/9b213ab8-2937-4de4-9550-baaa905da921?feedback_type=irrelevant_answer) | [Incorrect Sources](https://app.dosu.dev/response-feedback/9b213ab8-2937-4de4-9550-baaa905da921?feedback_type=incorrect_sources) | [Too Verbose](https://app.dosu.dev/response-feedback/9b213ab8-2937-4de4-9550-baaa905da921?feedback_type=too_verbose) | [Hallucination](https://app.dosu.dev/response-feedback/9b213ab8-2937-4de4-9550-baaa905da921?feedback_type=hallucination) | [Bug Report](https://app.dosu.dev/response-feedback/9b213ab8-2937-4de4-9550-baaa905da921?feedback_type=bug_report) | [Other](https://app.dosu.dev/response-feedback/9b213ab8-2937-4de4-9550-baaa905da921?feedback_type=other)</sup> GitHub link: https://github.com/apache/superset/discussions/33120#discussioncomment-12827014 ---- 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]
