Laris_Fdz
Cloud Apps
Joined 5 years ago
User Profile
User Widgets
Contributions
What is sipynb file format?
What is a sipnb file format for Jupyter notebooks import/export? I tried to google it and found absolutely nothing) The user case is the following: sometimes we need to further develop notebook's code that is already used on prod. So I would like to export a notebook and open it in Jupyter notebook locally. But I can only import it with sipynb format and cannot open it in Jupyter later. Any comments appreciated, Larisa2.7KViews0likes1CommentRe: How to switch off Pivot2 columns?
Hi, Guyraz, thank you for your reply. Indeed I have seen that script and tried to modify it but haven't succeed yet. I think I wasn't clear. The script you propose deals with the "Values", and I am looking for a way to let users switch on/off the columns without entering inside the widget. Larisa2.1KViews0likes0CommentsPivot2 export to csv format
On pivot2 table we have locale customization so thousands are separated with space and not with commas, decimal are separated with commas. When I try to export a pivot table to csv, our local setting are not applied so the numbers are downloaded in text format and are quite difficult to change. Does anyone know where these csv download settings are stored or whether it is possible to change them with a script?1.8KViews0likes1CommentHow to switch off Pivot2 columns?
I am looking for a script to switch off columns in pivot2. This option would be available to users, so I suppose I would link it to a Blox botton. The case is that we use dates in columns and several values. So when half of the month passes the table becomes quite extensive. I would like to be able to switch off columns and have values aggregated by the current month. I have tried to use dimention changer (days / months) but when the agregation is by months, the widget ignores the dashboard filter and shows all months available in the datamodel. Larisa2.2KViews0likes2CommentsColumn bar widget - color categories when there is more than one value
Usually, when you want to color categories, you would use "break by", but then you cannot have two values on the same graph: I needed to show past year's values (grey on the left widget bellow) but on the same time color the categories like they are on the right for the sake of clarity. I couldn't find a script that would suit and then it occured to me to apply conditional coloring according to the value in each category Hope someone else find it useful. Cheers, Larisa1.1KViews0likes0CommentsBlox Widget In pdf
Hi, I've got a blox table widget that is narrower than the above line of widgets. It has 15 columns (1 is the name of the category and 14 are values) When I export the dashboard to pdf (actually I send it in email as pdf) the blox table gets cut, showing only 11 columns, even though, as you can see in the printScreen bellow, the blox widget is still narrower than the line above. It looks like the blox widget has a predefined width, any idea how to change it1.4KViews0likes0CommentsPastDay formula
Hi, Sisense Community, I use DiffPastPeriod() and PastDay() to show previous day's values or to calculate the difference with the previous day. BU the problem is that I don't have data for Sundays and it seems like the formulas DiffPastPeriod() and PastDay() actually refer to the -1 day, not the previous day in the dataset so I cannot compare values on Monday (I would expect Saturday data to be compared to Friday's) and Tuesday (I would expect to campare Mondays' data with Saturday's). Is there a way to solve the problem? I was thinking abouat ranking the two recent days like 1 and 2 and filtering on that ranking. Is there a better way?Solved3.4KViews0likes4Comments