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 ...
Hi @harikm007 , I want to show previous 12 months of data from a selection I make on a month filter. But the user should be able to change the month and the previous 12 month will get updated based on the selection For e.g. If I select Dec-2022 then ...
Hi all, Sometimes, you can manage two tables in an Elasticube, one for historical data, and other for a month data. When the date goes to the next month, this accumulated monthly data needs to be copied to the historical data. The data is managed by ...
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,
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...
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!
Anyone have a thought as to why a widget would show on a PDF preview, but not on the saved PDF file or when printed? The widget does have script to have a resulting value changed to text. Windows based version First snip is the PDF preview, second is...
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...
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...
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
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 ...
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...
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.
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 segmen...
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 ...
