Hi Pigment team,
I’m trying to add empty rows into my Table block, so that I can separate some categories of expenses from each other:
I tried to create and add empty “Placeholder” Metric, however it requires a name and I can’t simply leave it empty. Is there another way to add such empty rows between items?
Best,
Dastan
Best answer by francois
View original
+14
Hi Dastan,
While you can easily have a blank name as a dimension display name, it looks like you cannot with metrics.
I recommend you create a technical metric with no dimension (whatever the format). You can use it in a table by simply adding it and renaming it to something minimal like a dot (.) or a dash (-) which I hope is minimal enough for your report.
To have several blank lines, you can right click on the name of the metric and click on Add this metric again to use this spacer multiple times.
Another solution would be to right-click on any line, add the metric again, and format it as invisible by unlinking background color and text color by clicking the lock between the pickers. Making them both white will “hide” both the name and the values. Make sure you click on Grid headers to also format the header of the row.
The following screenshot is the outcome:
These suggestions are clearly workarounds, I also think it would be best if we had more formatting options to present your tables directly in the desired format, however this is clearly a long journey!
In the meantime, I suggest you use a combination of both using an empty metric with unlinked colors to have a blank line in your table.
Hi Francois,
Thanks for the help. Second option is what we needed!
+11
Small addition:
you can also use the empty unicode character ⠀to rename your metrics and thus make them empty
“⠀” U+2800 Braille Pattern Blank Unicode Character (compart.com)
+14
Good point
Other Pigment users can then vote for these ideas and it helps our Product team understand what features are the most expected - we’ll probably build it eventually, but having a lot of votes ensures you get it faster!
Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.
