Thanks man! I plan on moving up to two videos a week from now on. So there's plenty more to come!

Glad you liked it. The rest of the SuiteAnalytics videos are in the full course, and won't be put on KZfaq. HOWEVER, if you go to the course it allows you a free preview of certain lessons including the part 2 of this Datasets video. So check it out at: supertraining.supersync.cloud/courses/netsuite-administrator-course

Hi Jeru, that's a good question. I've never tried to do two levels of grouping. It may not be directly possible, but I'm pretty sure you could rearrange things in the dataset until it achieved the basic concept. I'm found that while there aren't many people that have extensive knowledge of SuiteAnalytics, if you just play around with it for awhile you can get it to do most things you want.

Hi Sujin, I'm more than happy to help, but I can't tell what you're trying to do. Please write a more detailed explanation of what you've done and what isn't working.

@@SuperSuiteCris I tried to create a list of emails sent in Suite Analytics. I selected the Message dataset and dragged and dropped the fields. However, it returned zero rows, despite the fact that the email data is available. Thanks much for helping.

Hi Sujin, There are a few things that could be going wrong, but the most likely is that there is some criteria added that is excluding everything. Try to strip back the dataset to only include date (anything before today) and entity (include All Entities). Make sure these fields are added to the columns of the dataset and aren't dropped in as "AND" criteria (which happens if you drop the fields into the top row of the dataset). If that doesn't work, try tinkering around, removing things, adding them into different places if possible, etc. Again, it's hard to say definitively without looking at your Dataset, but you get the idea.

@@SuperSuiteCris yes I will try doing that. Thanks much!

@@SuperSuiteCris hi bro. It worked. Thankyou so much.. I'm curious to know is there a way to link three dataset in suite analytics? I attempted to create workbook report having three columns, count of emails, opps amount, count of event. These three columns are not related to each other I just want to join by month Sry for troubling you.... I couldn't find any resources in google.. And I'm new to netsuite... :))

Whoa, I never knew I had a second brother! How did you find me?! Funny enough, the SuiteAnalytics Certification has nothing to do with SuiteAnalytics. The exam only covers Reports, Saved Searches and Dashboard portlets/KPIs. It's definitely one of the easier certifications as you really just need to spend time getting familiar with those tools. You can certainly check out my Administrators Course, where I have about 10 videos covering Reports and Saved Searches, that will help. Within the next few months I'll do a course on passing the SuiteAnalytics certification.

@@SuperSuiteCris Thankyou so much brother, please make some videos related to a project on data analytics in Netsuite using the Netsuite data- to derive some valuable insights using dashboards

Hi Shiva! Can you clarify your request, are you asking for a video on how add SuiteAnalytics graphs/charts to your dashboard? If so, I have a video on that it just isn't on KZfaq. You can email me and I'll hook you up with that.

Thankyou for your prompt replies, I meant to say that we have lot of data related to Sales and Marketing, Procurement and sourcing etc in netsuite- Can you make make some projects related to actual data analysis for specific scenarios like to measure vendor performance or sales analysis in past few years or months and also inventory optimization as per the sales demand by using tools in netsuite analytics like datasets, workbooks, reports and dashboards?

Hi Shiva, ok sure. I'll try to make more videos covering specific SuiteAnalytics scenarios.