Good afternoon dear community. I need to create one chart and I have one event which comes from Segment service. I need to display in the chart the sum of incoming events for the previous 30 days. And also for every day during the past 30 days. For example, today is May 11, I need to display the number of events from May 11 to April 11 - this will be the 1st bar in the chart, then I need to display from May 10 to April 10 - this will be the 2nd bar in the chart and so on until the date interval from April 11 to March 11. That is, there will be 30 bars in the chart with intervals in the previous 30 days. The key is that it would not be necessary to manually select date intervals for 30 days, but that they would be set up automatically (the last 30 days were simply taken). I found that under each event you can add a where "Server upload time" condition. That is, there is a way to add 30 identical events and manually add the where "Server upload time" condition to each of them, but the problem is that the condition will need to be changed every day and this is inconvenient, the conditions should change automatically (the last 30 days).
1) Is it possible somehow in the "where" condition to get the current date and subtract 30 days from it?
2) Is there something similar to the SQL builder in Amplitude (I tried to find it but could not do it, when creating a chart I do not have the "Amplitude SQL" tab) with which you can achieve the desired result?
3) Is there any other way to achieve this?
Thank you for your time, any help would be greatly appreciated!
Best answer by Saish RedkarView original