You are viewing a plain text version of this content. The canonical link for it is here.
Posted to notifications@superset.apache.org by "Rohit-pawar902 (via GitHub)" <gi...@apache.org> on 2023/02/02 06:48:08 UTC
[GitHub] [superset] Rohit-pawar902 opened a new issue, #22952: Time-Sync/Time Mismatch in Dashboard-view and chart(clike table view in dashbord) reports
Rohit-pawar902 opened a new issue, #22952:
URL: https://github.com/apache/superset/issues/22952
Time-syn Problem on Dashboard view and Chart/table
I am having an chart named ReportFailInSchedule and I noticed that the **date are mismatching on the dashboard-view and Chart or table view of dashboard**
**Like :**
on dashboard I have same no of records but this date 2023-02-01 record 10 time and 2023-02-02 (2x-time)
And on table/chart view 2023-02-02 (11x-time) and this is exactly right according to query
So why in the Dashboard-view ,this date-mismatching problem is coming ? What things are causing this problem?
Any Idea?
@evans
--
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.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 commented on issue #22952: Time-Sync/Time-Mismatch problem in Dashboard-view and chart(clike table view in dashbord) reports
Posted by "rusackas (via GitHub)" <gi...@apache.org>.
rusackas commented on issue #22952:
URL: https://github.com/apache/superset/issues/22952#issuecomment-1414088901
Sounds like a caching issue... dashboards have a (configurable) caching layer to them, and I _think_ the chart details modal makes a fresh query via the API, so the data will be the latest and greatest (essentially skipping the cache).
There may be another nuance to this regarding timezone handling (see pending docs PR [here](https://github.com/apache/superset/pull/19056/files)).
Pinging/assigning @michael-s-molina and @codyml who know this modal particularly well and might be able to spot something else that I'm not, or provide more insight.
Also worth mentioning: The `evans` github user is not me and has nothing to do with this project. Poor guy gets pinged all the time by this community. ;)
--
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] Rohit-pawar902 commented on issue #22952: Time-Sync/Time-Mismatch problem in Dashboard-view and chart(clike table view in dashbord) reports
Posted by "Rohit-pawar902 (via GitHub)" <gi...@apache.org>.
Rohit-pawar902 commented on issue #22952:
URL: https://github.com/apache/superset/issues/22952#issuecomment-1439967299
It is caused because of checked **isTemporal flag** it will change the date to something else , As of now on Dashboard Page I can see the right date by un-checking the isTemporal flag in Dataset of chart.
Can you tell me Why?
@codyml
--
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] Rohit-pawar902 commented on issue #22952: Time-Sync/Time-Mismatch problem in Dashboard-view and chart(clike table view in dashbord) reports
Posted by "Rohit-pawar902 (via GitHub)" <gi...@apache.org>.
Rohit-pawar902 commented on issue #22952:
URL: https://github.com/apache/superset/issues/22952#issuecomment-1415930530
Thanks for reply
And I would not bother evans again.
As you said about caching-layer problem
But Its Not about Caching - Layer Problem because the **data and id** is exactly same just time is diffrent , I checked by appliying force - refreshal on them
Problem might be because of timezone handling ,
@michael-s-molina
Can You suggest what extra thing I will have to add/enable in config file other than this for timezone problem handling
```
# Druid query timezone
# tz.tzutc() : Using utc timezone
# tz.tzlocal() : Using local timezone
# tz.gettz('Asia/Shanghai') : Using the time zone with specific name
# [TimeZone List]
# See: https://en.wikipedia.org/wiki/List_of_tz_database_time_zones
# other tz can be overridden by providing a local_config
DRUID_TZ = tz.tzutc()
DRUID_ANALYSIS_TYPES = ["cardinality"]
```
--
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
Re: [I] Time-Sync/Time-Mismatch problem in Dashboard-view and chart(clike table view in dashbord) reports [superset]
Posted by "rusackas (via GitHub)" <gi...@apache.org>.
rusackas closed issue #22952: Time-Sync/Time-Mismatch problem in Dashboard-view and chart(clike table view in dashbord) reports
URL: https://github.com/apache/superset/issues/22952
--
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
Re: [I] Time-Sync/Time-Mismatch problem in Dashboard-view and chart(clike table view in dashbord) reports [superset]
Posted by "rusackas (via GitHub)" <gi...@apache.org>.
rusackas commented on issue #22952:
URL: https://github.com/apache/superset/issues/22952#issuecomment-1959920344
I'm not sure if this is still an issue in current versions of Superset (3.x). If it is, we can re-open this, or feel free to open a new issue with updated context and a reproducible case using example data. We're no longer supporting Superset 2.x or prior, and it's been a while since this thread saw any activity, so I'm closing this as stale.
--
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