Cappuccino.svg

Metabase Meet & Greet

Meet the WMSE team behind Metabase and other editors and friends of Metabase! Everyone is welcome, regardless if you are an active editor or simply interested in the platform. Ask questions, brainstorm and write queries, or simply chat about the future of Metabase.

The first Metabase Meet & Greet will be in November - help us pick the time.

User:Alicia Fagerving (WMSE)/Sandbox: Difference between revisions

From MetaBase
Jump to navigation Jump to search
No edit summary
No edit summary
Line 6: Line 6:


[https://metabase.wikibase.cloud/query/#PREFIX%20wb%3A%20%3Chttps%3A%2F%2Fmetabase.wikibase.cloud%2Fentity%2F%3E%0APREFIX%20wbt%3A%20%3Chttps%3A%2F%2Fmetabase.wikibase.cloud%2Fprop%2Fdirect%2F%3E%0ASELECT%20%3FtypeLabel%20%3Fitem%20%3FitemLabel%20%3Ftime%0AWHERE%0A%7B%0A%3Fitem%20wbt%3AP5%2Fwbt%3AP4%2a%20wb%3AQ21.%0A%3Fitem%20wbt%3AP5%20%3Ftype.%0A%3Fitem%20wbt%3AP15%20wb%3AQ21961.%0AOPTIONAL%20%7B%3Fitem%20wbt%3AP18%20%3Ftime%20%7D%20%23%20publication%20date%0ASERVICE%20wikibase%3Alabel%20%7B%20bd%3AserviceParam%20wikibase%3Alanguage%20%22en%2Csv%22.%20%7D%0A%7D%0AORDER%20BY%20%3Ftype Published on OR]
[https://metabase.wikibase.cloud/query/#PREFIX%20wb%3A%20%3Chttps%3A%2F%2Fmetabase.wikibase.cloud%2Fentity%2F%3E%0APREFIX%20wbt%3A%20%3Chttps%3A%2F%2Fmetabase.wikibase.cloud%2Fprop%2Fdirect%2F%3E%0ASELECT%20%3FtypeLabel%20%3Fitem%20%3FitemLabel%20%3Ftime%0AWHERE%0A%7B%0A%3Fitem%20wbt%3AP5%2Fwbt%3AP4%2a%20wb%3AQ21.%0A%3Fitem%20wbt%3AP5%20%3Ftype.%0A%3Fitem%20wbt%3AP15%20wb%3AQ21961.%0AOPTIONAL%20%7B%3Fitem%20wbt%3AP18%20%3Ftime%20%7D%20%23%20publication%20date%0ASERVICE%20wikibase%3Alabel%20%7B%20bd%3AserviceParam%20wikibase%3Alanguage%20%22en%2Csv%22.%20%7D%0A%7D%0AORDER%20BY%20%3Ftype Published on OR]
[https://metabase.wikibase.cloud/query/#%23defaultView%3AGraph%0APREFIX%20wb%3A%20%3Chttps%3A%2F%2Fmetabase.wikibase.cloud%2Fentity%2F%3E%0APREFIX%20wbt%3A%20%3Chttps%3A%2F%2Fmetabase.wikibase.cloud%2Fprop%2Fdirect%2F%3E%0ASELECT%20%3Ftopic1%20%3Ftopic1Label%20%3Ftopic2%20%3Ftopic2Label%0A%0AWITH%20%7B%0A%20%20SELECT%0A%20%20%20%20%28COUNT%28DISTINCT%20%3Fitem%29%20AS%20%3Fcount%29%20%3Ftopic1%20%3Ftopic2%0A%20%20WHERE%20%7B%0A%20%20%20%20%0A%20%20%20%20%3Fitem%20wbt%3AP15%20wb%3AQ21961.%20%23%20OPENREFINE%0A%20%20%20%20%3Fitem%20wbt%3AP15%20%3Ftopic1%2C%20%3Ftopic2%20.%20%0A%20%20%20%20FILTER%20%28wb%3AQ21961%20%21%3D%20%3Ftopic1%20%26%26%20wb%3AQ21961%20%21%3D%20%3Ftopic2%20%26%26%20%3Ftopic1%20%21%3D%20%3Ftopic2%29%0A%20%20%7D%0A%20%20GROUP%20BY%20%3Ftopic1%20%3Ftopic2%0A%20%20ORDER%20BY%20DESC%28%3Fcount%29%0A%0A%7D%20AS%20%25results%0A%0AWHERE%20%7B%0A%20%20INCLUDE%20%25results%0A%20%20%0ASERVICE%20wikibase%3Alabel%20%7B%20bd%3AserviceParam%20wikibase%3Alanguage%20%22en%2Csv%22.%20%7D%0A%7D%0A CO-OCCURING TOPICS]




SESSION: {{q|Q23072}}
SESSION: {{q|Q23072}}
</div>
</div>

Revision as of 11:47, 3 May 2024