Numeric facet management

[Parthasarathi Mukhopadhyay]

Dear all

How do we solve this problem?

In numeric facet we need to create ranges like this

0 to 100

101 to 500

501 to 1000

1001 to 1500 and so on.

But we are not able to set that fine range - it is working fine with 0 to 100 but it is almost impossible to set sliders at 101 or 501 or 1001 positions (taking 100, 500, 1000 instead).

As a result there is overlapping of results and total values are not matching for obvious reasons.

Is there any way out through which we can set range manually? What are we missing?

Best regards

-----------------------------------------------------------------------
Parthasarathi Mukhopadhyay
Professor, Department of Library and Information Science,

University of Kalyani, Kalyani - 741 235 (WB), India
-----------------------------------------------------------------------

[Jevon, Graham]

What about a custom text facet or custom numeric facet?

 

If(value > 100 and value <  501,”include”,”exclude”)

 

I haven’t tested that statement, but something like that

--
You received this message because you are subscribed to the Google Groups "OpenRefine" group.
To unsubscribe from this group and stop receiving emails from it, send an email to openrefine+...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/openrefine/CAGM_5uZ-v3zCfzia2fUR6_WnbFMDOu4Cku0sRm13qptqPM4pXw%40mail.gmail.com.

 
******************************************************************************************************************

Experience the British Library online at www.bl.uk

The British Library’s latest Annual Report and Accounts : www.bl.uk/aboutus/annrep/index.html

Help the British Library conserve the world's knowledge. Adopt a Book. www.bl.uk/adoptabook

The Library's St Pancras site is WiFi - enabled

*****************************************************************************************************************

The information contained in this e-mail is confidential and may be legally privileged. It is intended for the addressee(s) only. If you are not the intended recipient, please delete this e-mail and notify the postm...@bl.uk : The contents of this e-mail must not be disclosed or copied without the sender's consent.

The statements and opinions expressed in this message are those of the author and do not necessarily reflect those of the British Library. The British Library does not take any responsibility for the views of the author.

*****************************************************************************************************************

Think before you print

[Thad Guidry]

Hi Parthasarathi,

If you want to have groups of row numbers to facet against then divide the row.index by a number

row.index/100

row.index/1000

and sometimes another type of facet (custom text, custom numeric, etc.) can work better depending on the situation.

After your last week's question ;-) , I saw we needed to improve the docs with that note so I wrote it up, but it hasn't been merged yet:
https://github.com/OpenRefine/OpenRefine/pull/4062/files

Thad

https://www.linkedin.com/in/thadguidry/

https://calendly.com/thadguidry/

To view this discussion on the web visit https://groups.google.com/d/msgid/openrefine/CWXP265MB29515F857D4FA781A893ACB482E59%40CWXP265MB2951.GBRP265.PROD.OUTLOOK.COM.

[Parthasarathi Mukhopadhyay]

Dear Graham and Thad

Thanks for coining the ideas .... We applied this on the basis of the ideas you have given us:

Facet >> Custom Text facet >> and(value >=101, value <500) >> Nicely giving facets values -

false 24122

true 186

The advantage, apart from obtaining exact values, is that we don't have to create additional columns for getting these values.

Thanks a lot to both of you.

Yes Thad, thanks a lot for the PR. It explains this requirement nicely and we got some additional ideas too from the PR.

Thanks again

Best regards

To view this discussion on the web visit https://groups.google.com/d/msgid/openrefine/CAChbWaO-zS7jd2fhDFk2Ot%2BZJhvTbhL6%2B0ZHRWeqZcRW3W%3DhLA%40mail.gmail.com.