Sorting in Data view with Detail by

Maik Burghardt · 2025-07-01T07:18:41+00:00

There was an error rendering this rich post.

Maik Burghardt

Hi can someone shade some light into sorting logic with "Detail by" activated?

a - is on the first spot and Detail by Year is activated - However it isn't shown in the preview

When I move it to spot - b -

I can see Occ TY by Year - However now the order of the other columns is screwed.

Any idea how to fix this?

Thanks Maik

Find more posts tagged with

Dataview

Accepted answers

All comments

Helmut Heimann

Hi @Maik Burghardt ,

have you tried using the year in the columns instead of "detail-by"? If not, what's the downside?
What's the reason for using detail by?

What's the order you want to achieve?

Best,
Helmut

Maik Burghardt

Secondly: I have selected multiple years. I can see all 3 years for some columns but not all for all columns

Maik Burghardt

Well first of all it is dynamic - I want to see 2022 / 2024 or 2022/ 2023 / 2025 to make comparison.

Freezing the selection is not dynamic.

Additionally it is faster to get all the information intead of adding tones of columns for each year.

The order I want to achieve is:

All columns for OCC TY are next to each other - similar to Guests

Helmut Heimann

Hi @Maik Burghardt ,

is "show all" ticked on the columns/rows?

Can all blocks you want to see by column provide data for the current selection?

Best,
Helmut

Helmut Heimann

Hi @Maik Burghardt ,

what I meant by "year in the columns" was putting the entity year in the x-axis (not as a block). That would not mean any additional block for separate years.

Best,
Helmut

Maik Burghardt

Just did that. and added a few place holder algorithms to order it.

However that is very inefficient.

Maik Burghardt

I think the "Detail by" doesn't work as intended.

Helmut Heimann

Hi @Maik Burghardt ,

there are some restraints to using "detail by" as compared to utilizing the x-axis. So long you don't use any algorithms, it's working fine—but they can cause trouble in aligning and sorting.

This example does not use any algorithms

The first uses the x-axis, the second uses the detail-by.

Now, with an algorithm (b-c) at the end of the blocks, it becomes

If the algorithm is the first block, it will look like this

Just moved, still detail by (which seems entirely ignored).

If I put the algorithm between a and b, it becomes like this

Which unfortunately still is not reflecting the desired result.

And that is because cubes and algorithms are treated differently by the "detail-by" functionality (the algorithm does not have any dimensions).

My advice would be to use "detail by" only in those cases where you want to be more or less detailed in the columns than the x-axis would suggest (for instance the year in the x-axis for PY values and the current year detailed by month).

Best,
Helmut