eschutho opened a new issue, #27432: URL: https://github.com/apache/superset/issues/27432
## [SIP] Proposal for Visualizations with Time Comparison Data ### Motivation We want to be able to look at data and easily compare the values to previous periods. We currently have line charts with time shifts, but there are a few limitations: - the current time shifts only apply to a fixed period of ten choices. In this case for example, if you want to compare this year's black Friday to last year's black friday, comparing to 1 year ago or even 52 weeks ago will not give you the data that you need. - the current time shift do not currently contain information regarding the delta or direction of the change, and the viewer needs to interpolate that data on their own. ### Proposed Change We'd like to add time comparison visualizations to three charts: table, line and bar. For table, we would add additional columns for the time shifted value, the delta and the percentage, as well as an arrow showing direction: <img width="1133" alt="Screenshot 2024-03-07 at 3 54 06 PM" src="https://github.com/apache/superset/assets/5186919/74fcaed7-87af-4e15-8988-aaf11e37c984";> The extra data columns can be collapsed and sorted. Selecting time ranges in the left toolbar would look like this: <img width="225" src="https://github.com/apache/superset/assets/5186919/9740146f-212b-4692-99a2-ab46f0bf57b8"/> Dropdown expanded <hr> <img width="225" src="https://github.com/apache/superset/assets/5186919/be26a8ef-2c3e-4af9-9490-6c44d3005fc9"/> A custom range can also be selected After dates are selected, we will show the effective time ranges in the toolbar. <img width="225" alt="Screenshot 2024-03-07 at 3 55 11 PM" src="https://github.com/apache/superset/assets/5186919/0f6af80b-3f2d-476f-b252-f9f99888e4be";> For the customize toolbar, we would add the ability to choose the color for the increases/decreases. So as not to assume that an increase is positive, etc. <img width="225" alt="Screenshot 2024-03-07 at 3 55 17 PM" src="https://github.com/apache/superset/assets/5186919/a5ab744d-dd2b-495a-a0f0-71beab14f9a0";> ### New or Changed Public Interfaces Changes in the UI are shown above. Because we also want to show the time range in the UI, we will need to calculate that separately. This may require a new API endpoint. ### New dependencies No new dependencies ### Migration Plan and Compatibility No new migrations ### Rejected Alternatives Describe alternative approaches that were considered and rejected. -- 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-unsubscr...@superset.apache.org.apache.org For queries about this service, please contact Infrastructure at: us...@infra.apache.org --------------------------------------------------------------------- To unsubscribe, e-mail: notifications-unsubscr...@superset.apache.org For additional commands, e-mail: notifications-h...@superset.apache.org
