GitHub user Aruneem created a discussion: Custom Sql query Problem
1) I have a dataset with two columns: Brand and Sales.
2) One brand, Metformin, appears multiple times. Some sales values are also
repeated (50, 30).
3) I want to create a Total column that shows the sum of sales for distinct
brands. For example, the sales values are 40, 50, 50, 30, and 30,
which add up to 200. Since Metformin is repeated twice, it should be
considered only once.
4) I will be writing this query in custom SQL at the chart level, not on the
actual database, so I cannot
use
SELECT * FROM ...
[Dataset.xlsx](https://github.com/user-attachments/files/27625227/Dataset.xlsx)
@dosu
GitHub link: https://github.com/apache/superset/discussions/40045
----
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]
