Identify Unused Fields on Cube
As our reporting needs and abilities change over time some fields on a cube become unnecessary. Has anyone found a way to identify what fields are NOT being used to easily trim down cubes? Thanks,
Forum Posts
Elasticube Custom Table Dashboard Dependencies
Similarly to viewing dashboards dependents on an elasticube, is there a way to view dependencies of tables (custom or otherwise)? The use case is removing tables that have been created but are no longer needed. There is no quick way identifying if ...
Resolved! Reading data from SmartSheet
Can anyone perhaps assist with helping with information on how to read data directly from a document in SmartSheet? Has anyone been able to do this that can provide guidance on this? Thanks a million!
How to set two filters using a Input.date blox widget?
Hi, I currently have two filters that apply to different widgets on my dashboard. Note that the two filters have different grains, one is at day and the other is at month. I have a single blox widget with a Input.date. Is there any way to add a butto...
Tabber selected filters
Hi, I have two tabbers for two different teams for eg: Sales and Marketing to view their respective metrics on their respective tabbers. I also have a filter name called 'Manager' to filter those who head each of these team. I want to default one man...
Parsing variable length string
I am working with a column in my EC data model which is a variable length string delimited by commas. Here are a couple examples: I would like to separate out (flatten) the string to extract the individual elements from it. What is the best way to a...
How do I use the same underlying query to update/run two seperate charts?
Hi all, My first post here, so please let me know if I have not done this the right way. I had a question regarding periscope dashboards and charts. Let's say I have got two charts that have the same underlying query but one chart shows e-commerce co...
Highlight Max and Min values of a Line chart using JS or Formula
Hi Team, I need a hep, I have a line chart with one series and I need to highlight Max and Min values in the same chart. Could you please help me how to achieve this. Thanks SNH
How to change my widget breakdown with a viewer license (could not go to edit setting) ?
Hello, Is there a way to change my widget breakdown with a viewer license (could not go to edit setting) ? I mean I have 1 widget broken down by Client Segment (see below) And I want to be able to switch "Client segment" into "Length of Rental segm...
Formatting Pivot Header Rows And Columns Via CSS
Hi Team, Use this script to format the header rows and columns of a Pivot table. widget.on('domready', function(sender, ev){ $('div.p-container table').css({'width':'90%','table-layout':'fixed'}); // $('.p-container .p-fixed-cols, .p-container...
Line Chart - X-Axis label customization (granularity, formatting, frequency, first/last values)
When creating a line chart, the X-Axis of the chart may require customization (e.g., number of labels, the format of labels, special handling of first/last values, etc.) Scenario #1 - Reducing the number of labels (by half) Add the following script t...
Builds succeed, but records missing
Has anyone else run into a situation where Elasticube builds succeed, but only return a partial set of records? I'm finding that it is only happening in our largest Redshift table. There are 1.5 million records...the build is shown as successful but ...
Resolved! Displaying url query results as images
Hi there. We have in our database the url paths to images (such as items for sale, business logos) and we would like to show it in a results table column. Is there a way to do that easily?E.g. Google Sheets IMAGE() function: https://support.google.c...
Report Manager: Dynamic Widget Title
We are using Report Manager to send automated reports for some of our dashboards. We have scripts on our widgets that will change some of the titles depending on the code filter selected. The scripts work fine on the dashboard, however, they are not ...
Add tooltip to indicator visual
How to add tooltip to an indicator visual help me out
