[chart] Replace Big Number with Big Card

[kamalkeshavani-aiinside]

Is your feature request related to a problem? Please describe.
I would like to show a single metric/dimension value from db in a report. Currently the only option for that is Big Number chart type, which can work with only Numbers.

Describe the solution you'd like
Instead of Big Number, a new chart type like 'Big Card' or 'Big Value' should allow any data type like datetime, string, %, etc. along with some subheader text as it allows now.
And ofcourse, d3 formatting to set the Big Value formatting style.

Describe alternatives you've considered
An alternative could be supporting SQL query results in Markdown component of dashboard. Users can setup their formatting style in markdown, and get the values from SQL query. But this solution will need extra effort to support filtering effects.

[junlincc]

@maloun96 🙏

[inesplc]

Also could use this feature!
Our current work around is to use a word map chart in a dataset that returns only one series, but obviously this is not its intended use.

Similar issues were raised in #1784, #2919 and #6771 but were never finished.

[junlincc]

@kamalkeshavani-aiinside @inesplc can you send us the link to the library? thanks!

[kamalkeshavani-aiinside]

@junlincc what library are you asking about?

[jdbranham]

Related - apache-superset/superset-ui#1390

[jhult]

Looks like there is some good activity happening on apache-superset/superset-ui#1390. We would love to see this feature.

[stale]

This issue has been automatically marked as stale because it has not had recent activity. It will be closed if no further activity occurs. Thank you for your contributions. For admin, please label this issue .pinned to prevent stale bot from closing the issue.

[jhult]

Looks like the new PR (in this repo) is still active: #17903

[sfirke]

Here's a very minimal example of a Handlebars chart (new in 2.0.0) that makes a chart with a single text value. TotalPropertyValue is a column in my dataset.

Data is "Raw Records" with a single row. I wanted the value to look exactly like this and in order to get both the $ prefix and B suffix I had to process the value into a string outside of Superset.

EDIT: I would now suggest for the Handlebars CSS instead of what's in my image above:

.handlebars {
  font-size: 5em;
 }

Changing the font size of a p element may affect Markdown elements on a dashboard.

[kamalkeshavani-aiinside]

@sfirke Thank you.
With Handlebars I think we can achieve what is requested in this feature request, so closing this for now.