The Sisense for Cloud Data Teams Community
Welcome to Sisense for Cloud Data Teams! The documentation pages here hold lots of helpful guides to Sisense specific querying and charting. However, many customers have also found certain tips and tricks to be helpful while working in Sisense. The Sisense for Cloud Data Teams Community is a place to network and share these tips and tricks with other customers. Below is a list of popular community posts.
Filters
- Custom Date Range Filter
- Custom Aggregation Filter
- Filters in Case When Statements
- Using The Built-In Date Range Filter to Dynamically Update BigQuery Results
- Using Filters in the Group By Field
- Filter Out Selected Values
SQL Tips
- Cohort Grid Total Row/Column
- Generate Series in Redshift and MySQL
- Everything About CTEs
- Cross Joining to Control Cohort Grid Ordering
- Excluding Data that Isn't Fully Baked
- Additional Date Aggregations (Aggregating by 5 Minute Intervals)
Python/R
- Pivoting and Melting Dataframes (R and Python)
- Number Overlay with Additional Data (Python)
- Change in KPI Chart (Python)
- Window Functions in Python
- Preserving Colors across Multiple Charts in R
- Dealing with Missing Values in Python
- Making R charts look like Periscope Charts
Data Visualization Tips
- Comparing a KPI to a Benchmark
- Chart Type - Bullet Charts
- Chart Type - Funnel Chart
- Chart Type - Waterfall Chart
- Chart Type - Control Chart
- Chart Type - Gantt Chart
- Chart Type - Gantt Chart (Python)
- Radial Bar Charts (Python)
Embeds
Warehouse
Reference Datasets/CSVs
