GitLab Data Team, 25 Sep 2020

Previous Meeting Next Meeting

⏯

youtube image

►

From YouTube: Data Discovery Set Function in Sisense

Description

Tutorial on how to use the Data Discovery Function in Sisense.

A

Hi everyone I'm going to show you how to use the data discovery function in science. So if you're not familiar with sql- and you wanted to look around our data, you can opt to use this function, so we only need to drag and drop here. No coding is needed so um as an example we'd like to get the total number of per month, just like what this chart is showing.

A

So this is how we would do it by using the discovery function. So, first, we need to choose which data set. We are using, in this case um we're using the usage being marked, and then we can also see here all the fields that is included in that data set.

A

Now we wanted the data to be on a monthly basis, so we just drag this three month and then drop it here and then we can choose month and as we're counting the total instances, we actually need to count the distinct number of new ids.

A

So we need to drag new id from here and then drop to y-axis, and then we can choose count distinct.

A

Now this chart actually already shows the number of instances per month, but we'd like to filter this out to self-manage. Only because that's what we can see here, we only need self-managed.

A

So to do that um we have the filters filled here. um We drag the pink source.

A

And then filter it only to self managed.

A

And then, in this chart, the latest data is from november 2019. We can filter it here by using the date id.

A

And then greater than or equal to 2019 november.

A

So now we are only seeing data from november 2019 up until the current month, and then another filter we'd like to add here is the last thing in one. This should be true.

A

Okay, now here this chart is actually in number overlay, with the discover function we can choose which chart you wanted to use here. So in this case number overlay, and then here we can choose which chart we want to see with um with the number view id. So we can use bar and then in the chat format we can choose not to round numbers.

A

So now we're actually seeing the same number here and here the only difference is that here we are using the sql code, while here we are using discovery function. Now, if you wanted to see how to do this by using sql, you can click on this one, and you will see here how to create the chart using.

A