You are viewing a plain text version of this content. The canonical link for it is here.
Posted to notifications@superset.apache.org by GitBox <gi...@apache.org> on 2022/03/22 18:35:02 UTC
[GitHub] [superset] prosdev0107 opened a new pull request #19316: fix(explore): make to convert null to N/A in view results
prosdev0107 opened a new pull request #19316:
URL: https://github.com/apache/superset/pull/19316
### SUMMARY
NULL values not showing up in View Results in Explore
### BEFORE/AFTER SCREENSHOTS OR ANIMATED GIF
<!--- Skip this if not applicable -->
BEFORE:
![image](https://user-images.githubusercontent.com/47900232/159550566-80e6a11d-6056-458b-889c-ffdbc84501b2.png)
AFTER:
![image](https://user-images.githubusercontent.com/47900232/159550460-5b3120f1-44ec-4eb8-8b2b-e95950699e91.png)
### TESTING INSTRUCTIONS
How to reproduce the issue
1. Go to Chart Table. (can try with cleaned_sales_data datasets)
2. Set the Group BY as territorry field
3. Set the Metrics as SUM(price_each)
4. Run the chart
5. Table has the null value, this is displayed as N/A
6. But in View results, Table don't show null value as N/A like viz chart table.
### ADDITIONAL INFORMATION
<!--- Check any relevant boxes with "x" -->
<!--- HINT: Include "Fixes #nnn" if you are fixing an existing issue -->
- [ ] Has associated issue:
- [ ] Required feature flags:
- [ ] Changes UI
- [ ] Includes DB Migration (follow approval process in [SIP-59](https://github.com/apache/superset/issues/13351))
- [ ] Migration is atomic, supports rollback & is backwards-compatible
- [ ] Confirm DB migration upgrade and downgrade tested
- [ ] Runtime estimates and downtime expectations provided
- [ ] Introduces new feature or API
- [ ] Removes existing feature or API
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: notifications-unsubscribe@superset.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: notifications-unsubscribe@superset.apache.org
For additional commands, e-mail: notifications-help@superset.apache.org
[GitHub] [superset] prosdev0107 commented on a change in pull request #19316: fix(explore): make to convert null to N/A in view results
Posted by GitBox <gi...@apache.org>.
prosdev0107 commented on a change in pull request #19316:
URL: https://github.com/apache/superset/pull/19316#discussion_r832546712
##########
File path: superset-frontend/src/explore/components/DataTableControl/index.tsx
##########
@@ -49,6 +50,10 @@ import {
unsetTimeFormattedColumn,
} from 'src/explore/actions/exploreActions';
+export const CellNull = styled('span')`
Review comment:
it works
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: notifications-unsubscribe@superset.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: notifications-unsubscribe@superset.apache.org
For additional commands, e-mail: notifications-help@superset.apache.org
[GitHub] [superset] prosdev0107 commented on a change in pull request #19316: fix(explore): make to convert null to N/A in view results
Posted by GitBox <gi...@apache.org>.
prosdev0107 commented on a change in pull request #19316:
URL: https://github.com/apache/superset/pull/19316#discussion_r832543536
##########
File path: superset-frontend/src/explore/components/DataTableControl/index.tsx
##########
@@ -306,6 +311,9 @@ export const useTableColumns = (
if (timeFormattedColumnIndex > -1) {
return timeFormatter(value);
}
+ if (value === null) {
Review comment:
@diegomedina248
Resolved.
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: notifications-unsubscribe@superset.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: notifications-unsubscribe@superset.apache.org
For additional commands, e-mail: notifications-help@superset.apache.org
[GitHub] [superset] diegomedina248 commented on a change in pull request #19316: fix(explore): make to convert null to N/A in view results
Posted by GitBox <gi...@apache.org>.
diegomedina248 commented on a change in pull request #19316:
URL: https://github.com/apache/superset/pull/19316#discussion_r832531519
##########
File path: superset-frontend/src/explore/components/DataTableControl/index.tsx
##########
@@ -49,6 +50,10 @@ import {
unsetTimeFormattedColumn,
} from 'src/explore/actions/exploreActions';
+export const CellNull = styled('span')`
Review comment:
`styled.span` should work
##########
File path: superset-frontend/src/explore/components/DataTableControl/index.tsx
##########
@@ -306,6 +311,9 @@ export const useTableColumns = (
if (timeFormattedColumnIndex > -1) {
return timeFormatter(value);
}
+ if (value === null) {
Review comment:
I think this should be before the timeFormatter, if the value is NULL it might crash it.
Can you test it out? (pass null directly or force it somehow, to see what happens there)
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: notifications-unsubscribe@superset.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: notifications-unsubscribe@superset.apache.org
For additional commands, e-mail: notifications-help@superset.apache.org
[GitHub] [superset] rusackas merged pull request #19316: fix(explore): make to convert null to N/A in view results
Posted by GitBox <gi...@apache.org>.
rusackas merged pull request #19316:
URL: https://github.com/apache/superset/pull/19316
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: notifications-unsubscribe@superset.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: notifications-unsubscribe@superset.apache.org
For additional commands, e-mail: notifications-help@superset.apache.org
[GitHub] [superset] codecov[bot] commented on pull request #19316: fix(explore): make to convert null to N/A in view results
Posted by GitBox <gi...@apache.org>.
codecov[bot] commented on pull request #19316:
URL: https://github.com/apache/superset/pull/19316#issuecomment-1075590099
# [Codecov](https://codecov.io/gh/apache/superset/pull/19316?src=pr&el=h1&utm_medium=referral&utm_source=github&utm_content=comment&utm_campaign=pr+comments&utm_term=The+Apache+Software+Foundation) Report
> Merging [#19316](https://codecov.io/gh/apache/superset/pull/19316?src=pr&el=desc&utm_medium=referral&utm_source=github&utm_content=comment&utm_campaign=pr+comments&utm_term=The+Apache+Software+Foundation) (308e39c) into [master](https://codecov.io/gh/apache/superset/commit/d10a3d8bbad9efec53b372c1962cf8e1eab9d7ce?el=desc&utm_medium=referral&utm_source=github&utm_content=comment&utm_campaign=pr+comments&utm_term=The+Apache+Software+Foundation) (d10a3d8) will **decrease** coverage by `0.00%`.
> The diff coverage is `25.00%`.
```diff
@@ Coverage Diff @@
## master #19316 +/- ##
==========================================
- Coverage 66.65% 66.65% -0.01%
==========================================
Files 1672 1672
Lines 64611 64615 +4
Branches 6505 6506 +1
==========================================
+ Hits 43066 43067 +1
- Misses 19862 19864 +2
- Partials 1683 1684 +1
```
| Flag | Coverage Δ | |
|---|---|---|
| javascript | `51.33% <25.00%> (-0.01%)` | :arrow_down: |
Flags with carried forward coverage won't be shown. [Click here](https://docs.codecov.io/docs/carryforward-flags?utm_medium=referral&utm_source=github&utm_content=comment&utm_campaign=pr+comments&utm_term=The+Apache+Software+Foundation#carryforward-flags-in-the-pull-request-comment) to find out more.
| [Impacted Files](https://codecov.io/gh/apache/superset/pull/19316?src=pr&el=tree&utm_medium=referral&utm_source=github&utm_content=comment&utm_campaign=pr+comments&utm_term=The+Apache+Software+Foundation) | Coverage Δ | |
|---|---|---|
| [.../src/explore/components/DataTableControl/index.tsx](https://codecov.io/gh/apache/superset/pull/19316/diff?src=pr&el=tree&utm_medium=referral&utm_source=github&utm_content=comment&utm_campaign=pr+comments&utm_term=The+Apache+Software+Foundation#diff-c3VwZXJzZXQtZnJvbnRlbmQvc3JjL2V4cGxvcmUvY29tcG9uZW50cy9EYXRhVGFibGVDb250cm9sL2luZGV4LnRzeA==) | `71.62% <25.00%> (-2.67%)` | :arrow_down: |
------
[Continue to review full report at Codecov](https://codecov.io/gh/apache/superset/pull/19316?src=pr&el=continue&utm_medium=referral&utm_source=github&utm_content=comment&utm_campaign=pr+comments&utm_term=The+Apache+Software+Foundation).
> **Legend** - [Click here to learn more](https://docs.codecov.io/docs/codecov-delta?utm_medium=referral&utm_source=github&utm_content=comment&utm_campaign=pr+comments&utm_term=The+Apache+Software+Foundation)
> `Δ = absolute <relative> (impact)`, `ø = not affected`, `? = missing data`
> Powered by [Codecov](https://codecov.io/gh/apache/superset/pull/19316?src=pr&el=footer&utm_medium=referral&utm_source=github&utm_content=comment&utm_campaign=pr+comments&utm_term=The+Apache+Software+Foundation). Last update [d10a3d8...308e39c](https://codecov.io/gh/apache/superset/pull/19316?src=pr&el=lastupdated&utm_medium=referral&utm_source=github&utm_content=comment&utm_campaign=pr+comments&utm_term=The+Apache+Software+Foundation). Read the [comment docs](https://docs.codecov.io/docs/pull-request-comments?utm_medium=referral&utm_source=github&utm_content=comment&utm_campaign=pr+comments&utm_term=The+Apache+Software+Foundation).
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: notifications-unsubscribe@superset.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: notifications-unsubscribe@superset.apache.org
For additional commands, e-mail: notifications-help@superset.apache.org