Data designer needs ability to summarize by timeslice before transformation
I have a table of application outages/degradations in seconds by begin date. I want to use data designer to calculate an uptime or availability time by month for the various applications, but I can’t because data designer does not allow me to summarize a date field by timeslice (e.g. one month) before I do a transformation where I take sum of all outages in month and subtract that number from total seconds in a month, and then divide by total seconds in a month to get an uptime percentage.