Toad World® Forums

Date range as a series


#1

Any way in datapoint to run a query as a series in a date range? For example, run query for month of May showing results in a column as once a week in May.


#2

Something like this?

7851.Capture.jpeg


#3

Do you mean this way? TDP “Pivot Grid” functionality also has the ability to group dataset, could you provide more information for better understand your scenario?

Thanks,

Cindy


#4

Did you know that the Query Builder helps you build data ranges Toad functions and when run they generate the correct range at run time? and when you hover of the Toad function you can see the date range. Or if you press the hyperlink you can copy and paste the run time date range. Pretty cool [8-|]


#5

Yes,

Like that. A single query over a period of time broken down by week.


#6

Where a query of last month would look like this.