I'm trying to build the table with 8 columns. Do you have any clue on how to do it? I'm using avg(0) as column 1, min(0) to min(-5) as columns from 2 to 7 and measure values as the last column as you have shown.
Hi Estibaliz, it depends on the alignment you want to achieve! You can also use avg(0) for all 8 columns. That way all of them will have the same distance from each other. The way you described, the distance from one column to the next gradually grows, if that's what you want to achieve, then that's okay!
@@downtoearthdatatips In fact I wanted that all the columns have the same distance so your approach is what I was looking for! ^^ I've tried constructing all columns with min(0) and it seems to work well too. The only issue that I have now it's that my first column have 'Full Name' value and under it the 'ID' value, but some full names are too long :(( Do you know if there is a way to split the long names in more lines or something so they aren't cut?
@@estibalizmartinez3592 Unfortunately, I don't know a way to achieve this other than to (1) enlarge the width of the dashboard or (2) to set the dashboard to Fit Width instead of Fit Entire View. This way you might have the sheet scrolling horizontally and make the values more readable. I just tested it, it is an improvement but it doesn't completely fix the readability issue
@@downtoearthdatatips Yes, at least it's an improving. But after researching and try many ideas for days I didn't find any solution. I've ended asking Ludovic Tavenier and he has said that unfortunately this can't be fixed. It seems to be the limitation of this method