Sankey diagram for time series data in excel

Summary The question revolves around visualizing time series data in an Excel spreadsheet using a Sankey diagram. The goal is to illustrate transformations between different land types (Barren Land, Built up, Corp Land, Forest, Water, and Wetland) over a period of time (2000 to 2020) with 5-year intervals. The data consists of more than 7000 … Read more

How to add features when user pay online payment that time user get 5% discount not in COD payment?

Summary The problem at hand is to implement a discount system that offers an extra 5% discount for orders paid via online payment (prepayment) compared to COD (Cash on Delivery) payment. This requires integrating a conditional discount feature into an existing e-commerce platform, such as Shopify. Root Cause The root cause of the issue is … Read more

Does GCP M2VM (v5) & Storage Transfer Service support migration over VPN (private network) / CCI instead of public internet (http)?

Summary The question revolves around understanding the network path used by GCP Migrate to Virtual Machines (M2VM v5) and Storage Transfer Service (STS) during migrations from other clouds or on-premises environments to Google Cloud Platform (GCP). Specifically, it asks if these services can be configured to transfer data over a site-to-site VPN or Interconnect instead … Read more

Apple Pay button not showing in HyperPay paymentWidgets on Safari (Odoo backend)

Summary The Apple Pay button is not visible in HyperPay paymentWidgets on Safari despite a clean test HTML page and proper setup. The issue persists even after verifying Apple Pay and domain verification. Root Cause The root cause of this issue can be attributed to several factors, including: Incorrect configuration of HyperPay or Apple Pay … Read more

Will the awakened thread be able to read the latest data if write operations are performed on the data without locking before notify_one?

Summary The question revolves around the behavior of a multithreaded program where a producer thread writes data and then notifies a consumer thread using notify_one without proper locking. The key takeaway is that the behavior of the program is undefined due to the lack of synchronization between the threads. Root Cause The root cause of … Read more

How to trigger TimeSeriesEngine without waiting for next window data

Summary The problem lies in the delayed aggregation of 5-minute K-line data into 1-hour K-lines using DolphinDB’s TimeSeriesEngine. The current implementation waits for the next window’s data to arrive before triggering the aggregation, resulting in a significant delay. This delay is unacceptable for live trading. Root Cause The root cause of the issue is the … Read more

How to model and track monthly snapshot data in PostgreSQL when no natural key exists?

Summary The problem at hand involves loading a monthly snapshot dataset into PostgreSQL where the source does not provide a stable natural key for one of the entities. The goal is to track the current state and historical presence of rows without corrupting history or inventing false keys. The main challenges include: No explicit “exit” … Read more