Build Analytics
Showing results for 
Search instead for 
Did you mean: 

Forum Posts

Resolved! RSUM with Display Missing as Zero

When using the feature to Display Missing Values as Zeros, the results are what I would expect for a simple SUM. However, for an RSUM the results should fold the zeros into the value within RSUM and not return zeros for the RSUM itself.In this image,...

wallingfordce_0-1668564755888.png wallingfordce_1-1668565250014.png

Resolved! Filter down to records that contain two categories

Hello! I'm trying to filter some data in a widget. I want a list of "Disputes" that have two specific categories. The categories are not values in a single field, but rather are separate entries/rows on a related table. For example, if a Dispute has ...

Jake_Raz_0-1668444489845.png Jake_Raz_1-1668444636496.png
Jake_Raz by 7 - Data Storage
  • 4 replies
  • 0 kudos

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,

gwolfe by 9 - Travel Pro
  • 1 replies
  • 0 kudos

How to set two filters using a 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 Is there any way to add a butto...

Lander by 7 - Data Storage
  • 0 replies
  • 0 kudos

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!

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 ac...

vaibhav_j by 9 - Travel Pro
  • 0 replies
  • 0 kudos

Switchable Measure Buttons

Here is a script to add buttons to switch between different measures/calculation. For example, in below screenshot, each button represent different calculations and when we click on it, chart will show corresponding calculated values in Y-Axis. (The ...

harikm007_0-1666981305178.png harikm007_2-1666981359736.png harikm007_0-1667486464288.png
harikm007 by 13 - Data Warehouse
  • 2 replies
  • 1 kudos

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 .p-fix...

Sijo1995 by 7 - Data Storage
  • 0 replies
  • 0 kudos

Interval on X-axis labels on Chart

How to set an interval on X-axis for a continuous timeline so that the labels don't look so crowded? I want to show less labels on the X-axis and be able to control the interval.

Community Toolbox

Recommended quick links to assist you in optimizing your community experience:

Need additional support?:

Community Support Request