-
Notifications
You must be signed in to change notification settings - Fork 11
New issue
Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.
By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.
Already on GitHub? Sign in to your account
Improve Excel stats #461
Comments
Sorry, I should have added the documentation, the first argument of
Maybe we can think of something more generic than a drop-down. |
See attached sample with filtering additions: sample.xlsx
The reverse domain notation is Excel > 2019, so would be nice to add that in python instead (for sorting).
The improvements in this sample.xlsx are:
=TEXTJOIN(".";FALSE;SORTBY(TEXTSPLIT($C13;;".");SEQUENCE(LEN($C13)-LEN(SUBSTITUTE($C13;".";""))+1;1;0;1);-1))
, currently this is only supported in LibreOffice and Excel > 2019, so if this is easy to do in python it would be preferred to be added as a value. This column is useful for sorting (to group the apex to www, etc.).G13:CE100013
to support 100.000 at least in the formatting of Excel, instead of the current 5038 (5050-12), see Extend Excel conditional formatting and statistics to support > 5038 results #460.Current code location:
Internet.nl-dashboard/dashboard/internet_nl_dashboard/logic/report_to_spreadsheet.py
Lines 225 to 231 in 73a64d4
A2
with 'Total' or 'Filtered selection' (default on last).XML in the xl/worksheets/sheet1.xml for it is in this case:
<>
=OR($A$2="Total";SUBTOTAL(103;$A13)=1)
, this will result inFALSE
ifA2
is set to 'Filtered selection' and the row is not filtered (credits to @WKobes).=COUNTIFS($F$13:$F$100013;TRUE;G$13:G$100013;$F4)
, this can be 'dragged out' to all other header calculation rows, this will take into account if the stats should limit itself to visible (filtered) rows.Current formula code location here:
Internet.nl-dashboard/dashboard/internet_nl_dashboard/logic/report_to_spreadsheet.py
Lines 178 to 192 in 73a64d4
The text was updated successfully, but these errors were encountered: