cwerner13

Recently created

Least recently created

Recently updated

Least recently updated

cwerner13 / filter vs paramaeters

Created March 18, 2017 19:00

From https://www.interworks.com/blog/rcurtis/2016/06/02/tableau-deep-dive-parameters-filtering-across-data-sources

Quick Review Remember, filters are different than parameters. Filters are specific to a data source, parameters are not. Filters are created on the worksheet level. Parameters can be reused across the entire workbook. Both of these distinctions are the reason we must use a parameter instead of a filter when we are trying to filter across different data sources.

cwerner13 / 0_reuse_code.js

Created March 18, 2017 18:37

Here are some things you can do with Gists in GistBox.

	// Use Gists to store code you would like to remember later on
	console.log(window); // log the "window" object to the console

cwerner13 / Tableau_Start_R_Server.r

Last active March 18, 2017 18:51

start R Server (local)

	install.packages(“Rserve”)
	library(Rserve)
	Rserve()

cwerner13 / 01 create_paper_keyword.sql

Last active March 29, 2018 07:25

RegExp_Split_To_Table: PostgreSQL command to split and trim a text field and create one row for each keyword in the expression

	drop table ba_paper_keyword;
	create table ba_paper_keyword as
	(
	select p.id, p.keyword, count(p.keyword) count
	from
	(select id
	, trim (both ';,.:?()"' from regexp_split_to_table(lower(paper.keyword), E'\\\s+')) AS keyword
	from paper)p
	group by p.id, p.keyword
	)