We recently migrated to the Cloud version and no longer have access to our Zoho Analytics reports. I'm looking to recreate some reports in Power Bi or with the native SD+ reporting function. 

Has anyone created a report to show how long tickets have been open/pending based on period of time:
0 - 30 Days
31 - 45 Days
46 - 60 Days'
Over 60 Days'



In Zoho reports it involved linking a few schema's and creating a new formula:

if("Days Since Created">=0 and "Days Since Created"<=30,' 0 - 30 Days',if("Days Since Created">30 and "Days Since Created"<=45,'31 - 45 Days',if("Days Since Created">45 and "Days Since Created"<=60,'46 - 60 Days',if("Days Since Created">60,'Over 60 Days','Invalid Age'))))