Try glide ~ What kind of data structure is suitable for glide? ~

glide glide
この記事は約5分で読めます。

By the way, when dealing with spreadsheets in practice, there are many cases where not all data structures are clean, right?

In glide, any data can be linked for the time being. However, there are data formats that are suitable for cooperation.

Let’s look at the data structure of the spreadsheet suitable for data linkage so that it will not be displayed as expected when actually linking data.

Advertisements

What is the appropriate data structure for glide?

To make a conclusion, it is as follows.

Creating a row-oriented database

So what is a row-oriented database? If you’ve touched MySQL, you can easily imagine it, but it’s exactly that type.

Let’s actually look at the case as a base. This time, we are creating the theme of monthly performance trends that are often seen in management systems.

Data types that are not-suitable with Glide

I think that the typical monthly transition is as follows, with the moon growing horizontally.

Monthly transition sheet image

The monthly transition is growing horizontally every month so that it is suitable for making a graph. The graph expresses it neatly, and I think that it is generally easy to see the comparison that extends horizontally.

However, if you embed this in glide. ..

あれ?

In the image, I wanted the sales, gross profit, and operating income to be displayed on a monthly basis, but on the contrary, the monthly figures are displayed for each sales, gross profit, and operating income.

Well, there may be people who don’t mind this. ..

Try to improve the compatibility between glide and spreadsheet data

The display of monthly transition data that is easy to imagine is like this, isn’t it?

So how do you need to keep your data in order to do this? You can simply convert it to the row-oriented data described at the very beginning.

row-oriented data structure

This is row-oriented data when you want to display sales, gross profit, and operating profit by month, but if you do this, you can display the components by month with glide even if the contents are the same as before.

How to change the data in the horizontal direction to the vertical direction?

You can copy it simply and select Special Paste> Transpose and Paste.

You can also get the same result by using the transpose function.

=transpose(data range)

SUMMARY

We have introduced data that is compatible with glide and data that is not very good.

I think that employee lists and CRM-based data, which are easy to construct data according to the line-oriented concept, are very compatible.

On the other hand, data such as monthly accounting data is often column-oriented data that grows horizontally, so you need to be careful. Of course, there may be cases where you want to see the monthly transition by element instead of by month, so in that case there is no problem if you import something like a common monthly transition table.

コメント