jamnikej
Cloud Apps
Joined 4 years ago
User Profile
User Widgets
Contributions
Windows Pivot - sort column values
When we are building pivot tables, sometimes there is a need to sort things by the columns. If I want to show a pivot table with a Team Lead as the rows, Total Spend and Total Volume as the values, and Weeks as the the columns, I have no way to sort this to show the date in descending order and keep the table structure the way I want to see it. I think it would be helpful to have this option.361Views1like0CommentsRe: Bug on Windows: Filter doesn't show OK button
Hi, We had this issue and it has to do with your screen resolution/zoom. I noticed this was only happening with our embedded dashboards and only when the user couldn't scroll far enough down to get to the okay button. If you are experiencing this in iframes, increase the size of your iframe as a bandaid. Alternatively, decrease the zoom in your web browser and you should be able to see the okay button.729Views1like0CommentsSet Default Date Formats for All Data
Instead of having to manually set the same format for each date type over and over, it would be nice if you could set defaults for each date type (Year, Quarter, Month, Week, Day) somewhere and have everything default to that with the ability to change away from the default if needed. This could be done in the same area we set First Day of Week and Fiscal Year for the server.Add Hard Limit to Table (and Table with Aggregation) Rows Windows
We use jump to dashboard to allow users to view a data table to give them context to the chart they are looking at. For large data sets, this can lead to millions of records. The issue comes up when users try to then export this table. It would be nice if there was a way to set a hard limit to the number of records returned in a table/table with aggregation. When users try to download too large of a table, it impacts server performance for everyone, and the only way to really limit the tables right now and still allow them to be filterable on all required fields is not efficient (rank filter on a semi-unique identifier using the max of a unique identifier). I am looking to place simple guard rails into how much data can be exported into one file, I am flexible as to where this option presents itself and how - either a count of max records or a file size works. Having an option to set the max number of records returned in this widget type also would work. I would be fine with this as an option buried in the configuration settings page or within the admin page itself. I just want the option present somewhere.349Views1like0CommentsRe: Bar Chart Label from Secondary Series Script Update
Hi, this has been resolved in the original post. The solution is also pasted here below. DRay widget.on('render', function (widget, event) { // Define how each value series is used var displaySeriesIndex = 0, labelSeriesIndex = 1; // Define where to put the center line var centerLineValue = 0; // Get a reference to the highcharts object var chart = widget.queryResult; // Define a centerline to add to the chart var plotline = { color: 'black', dashStyle: 'solid', width: 2, value: centerLineValue } // Add the center line to the series chart.yAxis[0].plotLines = [plotline]; // Get a reference to the series var displaySeries = chart.series[displaySeriesIndex], labelSeries = chart.series[labelSeriesIndex]; // Loop through each data point in then display series displaySeries.data.forEach(function (data, index) { // Save a reference to the label value data.labelValue = labelSeries.data[index].y; }) // Remove the label series chart.series.splice(labelSeriesIndex, 1); // Get a reference to the sisense formatter var numberFormatter = prism.$injector.get('$filter')('numeric'); // Get a reference to the formatting mask of the label's series var mask = $$get(widget.metadata.panel('values').items[labelSeriesIndex], 'format.mask', {}); // Override the label formatter function chart.plotOptions.bar.dataLabels.formatter = function () { // Use the formatting of the label series, in order to create the value label var newLabel = numberFormatter(this.point.options.labelValue, mask); return newLabel; } })968Views1like0CommentsRe: Add functionality to limit RAM usage (Windows)
Hi, We are really looking for a way to control how much data can be cached by Sisense - when I look at this article - Data Groups In-depth - it looks like similar functionality is set up for linux. The article points out that complex aggregations and formulas can lead to increased caching of ram as dashboards are being accessed - this is what we are experiencing on our windows instance. I am happy with a tool like data groups being implemented on windows that would allow us to put a cap on how much ram a set of queries can take up, and setting up a time to auto-stop sources that are no longer being used. I am really looking for the data groups tool to be available for windows rather than a completely new tool be invented.990Views0likes0CommentsBar Chart Label from Secondary Series Script Update
Hi all, We have been using the script from Bar Chart - Value Label From Secondary Series (Hidden) for a while and I have noticed that it is no longer working on the latest version of windows. The original script is: widget.on('render', function(widget,event){ // Define how each value series is used var displaySeriesIndex = 0, labelSeriesIndex = 1; // Define where to put the center line var centerLineValue = 0; // Get a reference to the highcharts object var chart = widget.queryResult; // Define a centerline to add to the chart var plotline = { color: 'black', dashStyle: 'solid', width: 2, value: centerLineValue } // Add the center line to the series chart.yAxis[0].plotLines = [plotline]; // Get a reference to the series var displaySeries = chart.series[displaySeriesIndex], labelSeries = chart.series[labelSeriesIndex]; // Loop through each data point in then display series displaySeries.data.forEach(function(data, index){ // Save a reference to the label value data.labelValue = labelSeries.data[index].y; }) // Remove the label series chart.series.splice(labelSeriesIndex,1); // Get a reference to the sisense formatter var numberFormatter = prism.$injector.get('$filter')('numeric'); // Get a reference to the formatting mask of the label's series var mask = $$get(widget.metadata.panel('values').items[labelSeriesIndex], 'format.mask', {}); // Override the label formatter function chart.plotOptions.series.dataLabels.formatter = function(){ // Use the formatting of the label series, in order to create the value label var newLabel = numberFormatter(this.point.options.labelValue, mask); return newLabel; } }) I believe the part that the issue may be that this.point.options.labelValue no longer points to something, although I may be wrong. If anyone has any insight, it would be appreciated.Solved1.1KViews0likes2Comments