Comparison of results from several periods

Follow

Ivan1981

• April 19, 2024 12:07

Hello! I'm trying to solve a typical sales department problem: compare two sales periods, current and previous, in real time. Let's say a time series is 2 years long. Now it’s April, as we sell to the previous month in pieces, percentage, rubles, as more or less. I need to set up a comparison of the results of several periods, I don’t understand how to implement it. Thank you

0

• 

  Candido Dessanti

  • April 29, 2024 10:10

  Hi,
  
  To do this, you should use Windows functions, and I'm almost sure Immerse cannot generate queries using such functions. You should probably implement manually using custom data sources (add "ui/enable_custom_source_manager": true to your server .json file)  and using window function directly in your query.
  
  The problem with this approach is that is quite rigid, and the query will  fall back to CPU execution,

   

  0

  Comment actions Permalink
• 

  Ivan1981

  • May 08, 2024 20:00

  Thank you, I can’t do it. Can you give some example using preset data? Taxi or flights?

  0

  Comment actions Permalink

Please sign in to leave a comment.