Dataview: List all fields in a page as a table (wide to long)

anon63144152 · August 20, 2023, 8:17am

Dataview queries notes, so a simple table will render as in the image below.

A list of keys and values is possible but doesn’t create a two-column table (someone else will probably have a better solution).

Sample queries in the code block below.

Perhaps possible with DataviewJS or CSS.

Would be nice to have the option switch rows and columns easily.

github.com/blacksmithgu/obsidian-dataview

Switch row and column

opened 05:33PM - 11 Jun 22 UTC

jsphnecclia

feature-request

Although I think this feature would be useful in many scenarios, I'm currently w…anting it to set up my planner/habit tracker. The real problem I've come into contact with is white space vs data. I want to show as much data as I can in a single pane. I've tried splitting my habits into multiple tables, and renaming them with as few letters as possible. But the table separation is not what I want and doesn't let me view all tasks next to each other to compare, and sometimes it's hard to make or remember the minimal letter combinations (Say if I did that for books - The Book of Disquiet becomes 'dsqt'). Here is what I have now: (in journal/daily:) <img width="262" alt="Screen Shot 2022-06-11 at 12 15 41 PM" src="https://user-images.githubusercontent.com/51343659/173198021-c44a3071-2c53-4e5b-a07b-dc8f47e2d32d.png"> (in journal/biweekly:) <img width="701" alt="Screen Shot 2022-06-11 at 12 17 51 PM" src="https://user-images.githubusercontent.com/51343659/173198045-c231c48c-3566-4dd2-9591-8cb8e4e2dcf3.png"> (journal/biweekly view mode:) <img width="929" alt="Screen Shot 2022-06-11 at 12 17 11 PM" src="https://user-images.githubusercontent.com/51343659/173198032-28755582-a9c5-4af7-bc2d-904556f8d2cb.png"> At any rate they all take more whitespace than if the column/row were flipped and the file row were hidden (via "TABLE WITHOUT ID") Here is what I use currently. Its just red and black ink on graph paper. ![IMG_0260 2](https://user-images.githubusercontent.com/51343659/173198375-d8bbe908-2c2e-4c76-8a5c-64aea1e3eba5.jpg) Once you know each sequential check or x is the following day (which makes sense), you have access to the most historical and comparative data possible in a simple glance. I'm looking forward to using obsidian journal/daily as a daily journal, and I hoped to tie that in with a digital version of this tracker, but it's seeming like what I want is not possible. But it could easily be done if this swapping row and column feature was added. I'm sure such a simple tool will be of use to many, and I hope you consider adding it!

[a:: x], [b:: y], [c:: z]

Dataview queries notes, so a simple table will render as:

```dataview
TABLE
a, b, c
WHERE file.name = this.file.name
```

A list of keys and values is possible but doesn’t create a two-column table (someone else will probably have a better solution).

```dataview
TABLE WITHOUT ID
list(
"**a** " + a,
"**b** " + b,
"**c** " + c)
as "Fields"
WHERE file.name = this.file.name
```

Perhaps possible with [DataviewJS](https://forum.obsidian.md/t/how-to-switch-column-and-row-text-using-dataviewjs/58366) or [CSS](https://github.com/blacksmithgu/obsidian-dataview/issues/1177#issuecomment-1153026541).

Would be nice to have the option switch rows and columns easily.

https://github.com/blacksmithgu/obsidian-dataview/issues/1177