How to sort on Read Progress column?

[pdurrant]

Originally Posted by whiteowl

I do not want it to sort numerically. I want to see the same percentage as it is shown in bottom-right corner of the Viewer, and I want that column to be sortable as any normal human does sort percentage values. That is all I want.

Define the column to be floating point. Once you've done that and it's displaying pure numbers, right-click on the column heading in the main calibre window and choose "Edit column definition for <column name>".

In the dialog that appears, there's a field "Format for numbers"

If your numbers are between 0 and 1 in progress, enter {:.0%}
If your numbers are between 0 and 100, enter {:.0f}%

And then when sorting the column it will sort correctly using the underlying number, but display as a nicely formatted percentage.

[whiteowl]

Originally Posted by pdurrant

Define the column to be floating point. Once you've done that and it's displaying pure numbers, right-click on the column heading in the main calibre window and choose "Edit column definition for <column name>".

Ok. But after I done that - I have a column where I need to manually enter the values. This dialog does not have a field for entering expression which will produce the value automatically.

[pdurrant]

Ah - I had no idea that calibre had such a thing. I don't really use the bult-in viewer.

OK, change your column definition to have

{id:reading_progress(, 'number')}

instead of the percent thing, and then use the column formatting as I described earlier.

[thiago.eec]

Originally Posted by whiteowl

Sorry, I do not understand how you did it.

When I click on "Read Progress" template - it creates a "Column type: Column built from other columns". There is no field for formatting.
Attempt to change that column type to Float, adds a field "Format for numbers", but removes the "Template" field with the function.

So: how do you format the "Column built from other columns"?


Again: How? What should I click in the UI to get to the field where I would be able to type that expression?

Originally Posted by whiteowl

Ok. But after I done that - I have a column where I need to manually enter the values. This dialog does not have a field for entering expression which will produce the value automatically.

The floating point column must be filled manually or synced with another source (like Goodreads or a Kobo). It does not work with the viewer. I was just expliciting the difference in sorting.

To create such a column, you do like explained by @pdurrant.

As for the template I suggested. Proceed like this:
1) Open the 'Add your own columns' window
2) Select your 'Reading progress' column (the one that syncs with the Viewer)
3) Click the 'Edit' button on the right
4) In the 'Template' field, remove the standard template e copy/paste this:

program:
	format_number(reading_progress($id, '', 'pos_frac')*100, '{:.0f}')

5) Make sure it is set to sort by 'Number'
6) Apply and restart

[JSWolf]

This is how I have my percent column defined. It's integer but shows %.

01%
10%
100%

[whiteowl]

Originally Posted by thiago.eec

As for the template I suggested. Proceed like this:
1) Open the 'Add your own columns' window
2) Select your 'Reading progress' column (the one that syncs with the Viewer)
3) Click the 'Edit' button on the right
4) In the 'Template' field, remove the standard template e copy/paste this:

program:
	format_number(reading_progress($id, '', 'pos_frac')*100, '{:.0f}')

5) Make sure it is set to sort by 'Number'
6) Apply and restart

Ok. Looks easy enough. But the `Template` field is just a one-liner. You are suggesting to type two lines....
....
Ok, I see my mistake now. It should be really a one liner and word `program:` is essential.

program: format_number(reading_progress($id, '', 'pos_frac')*100, '{:.0f}')

Now we have a number 0-100 in the column.

That expression should be mentioned in documentation, I think.

[thiago.eec]

Originally Posted by whiteowl

Ok. Looks easy enough. But the `Template` field is just a one-liner. You are suggesting to type two lines....
....
Ok, I see my mistake now. It should be really a one liner and word `program:` is essential.

You could just copy and paste like I said. But you can also right click the template field and open the Template Editor, in case you need to create more complex templates. I always use the editor, so that's why the code I send had two lines. Also, you will be able to see all the functions available (plus documentation) and test your template as you type.

[whiteowl]

Originally Posted by thiago.eec

But you can also right click the template field and open the Template Editor,

Ahm... It is helpful to know about such functionality. But who can guess it???