Left margins on rows headers

Hello everyone,

Does anyone have a good trick to get the left indent on the rows in UX grids to go all the way to the left. I just can't get it to move over there, especially when I use a hierarchy. It's taking up a lot of space and makes the whole dashboard look bad.

I've tried:

I Show/ Hide only the level I want to see.
I created a Boolean variable in Properties module and use that instead of Show/Hide.
I've seen a solution to make the rows bigger in format so that the names wrap.

None of these options do much. Sometimes I get it but I can't replicate it later. See screenshot (so much space wasted on left and it cuts off the Names)

Appreciate any help. Thanks!

Accepted answers

BrunoRodriguez

Hello @DeepakK ,

That space is due to the summaries within the dimension that you have in the rows, which will guide the eyes to understand their level. Unfortunately, there is no way to hide that space by default. However, you can apply either of the following two options:

Create a line item with the code of the list in the rows and drag the row headers line towards the left in order to hide all the names.
Map the dimension in the rows with a list without summaries (parents). This option is not that good as it will get complicated to differentiate the summaries for the actual data.

I hope it makes sense.

All comments

BrunoRodriguez

Hello @DeepakK ,

Create a line item with the code of the list in the rows and drag the row headers line towards the left in order to hide all the names.
Map the dimension in the rows with a list without summaries (parents). This option is not that good as it will get complicated to differentiate the summaries for the actual data.

I hope it makes sense.

DeepakK

@BrunoRodriguez

Ok, I've used that first option. It's not my favorite since I'm taking away the native rows but it works.

Hopefully Anaplan can do something about this in future upgrades. I've seen other requests for the indents and column resizing to be more exact. I saw it got a lot of upvotes from our community.

Thanks!

BrunoRodriguez

Hello @DeepakK ,

I agree…, but it is what we have. I could suggest adding conditional formatting to show the summaries. It could add some value.

Cheers!

DeepakK

Yes, I formatted just that column as a different color so we can see a difference

Lolen

Thanks for the support and advice

axel.frot

Hello @DeepakK, @Lolen, @BrunoRodriguez
Here's my solution:
You can sort the dimension according to the value of a line. This will eliminate the indentation (partially or totally, you'll have to play with it),

Then, to improve the display, you can color-format according to the hierarchical level.

sophie33

Gratitude for the assistance and guidance.

louiedavis12

It's a fantastic blog post that is also really useful.

Visit the best discount and vouchers codes site: Gogetdeals

Quick Links

Can you help?

Unanswered questions

ERROR 16020 |-- Anaplan API: Invalid key path
Hello everyone, We are trying to use Anaplan Connect in order to push data from a dwh to Anaplan Data Hub. To do so, we need an authentication by token. We can't make it work, we receive the following error: ERROR 16020 |-- Anaplan API: Invalid key path Any suggestions? Thank you all in advance for the help! Michele
Azure SQL Connection, database name with Hyphens in Data Orchestrator
I am attempting to connect to an azure SQL database vis at the MSSQL connector in data orchestrator but am having issues and I believe it is due to hyphens in database name (which is a fairly standard naming convention I will note!) Example below (fake credentials) - has anyone else encountered similar and is there a way…
AnaplanXL Difficulties
Has anyone found success using Anaplan XL with Polaris models in a shared drive with or without concurrent users? My team has experienced a variety of errors, login failures, etc. sometimes it works, sometimes it doesn't. We've been recommended to save and edit files locally, which helps but certainly with its limitations…