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.
Data designer needs ability to summarize by timeslice before transformation
+1
+2Hi
You can get your desired output (summarize by date) in Data Desinger via a formula in the transform step and then grouping the data by this field. Let me know if this doesnt work or if you face any challenges here!
+1Thank you
Now I wish I could show months without data as 100%.
+1I thought I might be able to solve this by creating a simple custom object of the month start dates and the number 1, then merging this and subtracting outage percent from it but if the number is null it doesn’t treat it as 0:
Any ideas?
Sign up
If you ever had a profile with us, there's no need to create another one.
Don't worry if your email address has since changed, or you can't remember your login, just let us know at community@gainsight.com and we'll help you get started from where you left.
Else, please continue with the registration below.
Welcome to the Gainsight Community
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.