pausan-gh
Cloud Apps
Joined 3 years ago
User Profile
User Widgets
Contributions
Allow updating filters in Edit Chart page
When I'm editing or creating a new chart in SQL (chart being part of a bigger dashboard), I often find myself having to go in and out to change filters, or to just hardcoding values than later I have to change because inside the Edit Charts page I have no option of updating the filters. It would be great if there was a way of updating them inside that page. For example, imagine I'm creating a new chart page that requires a long query. I want to set it up so that it accepts certain filters. Good so far. Now imagine on the general dashboard the filter has "All dates" selected (just as an example). Then my query will take forever to run, and maybe, since I'm developing the query it would be nice for me to just select a smaller date range. There are more complex examples where the need of this becomes more clear. Imagine my query has multiple with clauses and/or joins with extra filters, etc... and I want everything to stay consistent. Then, if I have to go out and edit the filter, it might take a while for the dashboard to get all the data. For me, the ideal scenario would be to have a filter (e.g same as the dashboard where a chart is embedded on, or just based on the [name=value] attributes in the query) that is displayed in the edit area itself, so that I can select my parameters easily without having to hardcode those values only to remember to re-enable them again later, and I don't have to go in and out the chart to change the filters either. This feature would save me a lot of time and annoyance. Let me know if you need more real-world examples. But I found myself annoyed by this more than once. I think you have a great product, but it can be even better.546Views0likes0CommentsAdd "My Favorites" to the left menu
I can set dashboards as "Favorite" easily, with the click of a star, BUT there is no easy way for me to list and see my favourites later. Yes I can search them easily by pressing Ctrl+K and I will see which ones have an star or not, but it would be great to just be able to list them (or filter by them). On the left panel I can see Search, Topics, Dashboards, Views, ... I believe it would make perfect sense to add "Favorites" in there, so I could see straightaway my own favorite dashboards and/or filter them with just a click. Would enhance the user experience of your product1.5KViews2likes0CommentsBigQuery connection improvements when Editing Charts (descriptions, bytes to process, partitioned)
There are three features for BigQuery connections that would make your Edit Chart interface great. Show descriptions on the tables and fields: BigQuery supports adding a description to the fields and tables themselves. This information is often useful, and I find myself going to check the documentation on BigQuery consola in Google Cloud itself. We make use of this feature. Other databases also allow defining comments on tables and/or fields. It would be great to show them on the intervace via a tooltip when you put your mice over the field (right now is showing the type only) Display amount of data to be processed: one of the characteristics of BigQuery is that you pay by the amount of bytes you process. Building queries that are "efficient" is tricky task. Having a visual clue on the cost of the query allows me to understand better, before adding something in a dashboard or even running the query, how much data is going to consume. Also, if you tie that to the fact that I usually want to run the query using filters, and that there is no way for me to change filters in the editor, it makes my life miserable, because I need to copy the query, go to Google console, replace the generic filters [name=value] by real SQL filters, make a sense of the cost in SQL, etc... miserable experience. Show partitioned tables differently: For example, on Google Cloud BigQuery editor, partitioned tables are shown with a different icon than normal tables. Knowing if a table is partitioned, and knowing also which fields are the ones partitioned, would help to build efficient queries without leaving Sisense. Right now I find myself jumping in and out sisense. This takes time, and you are already showing all fields and tables in there, it would be great to just use a different icon for partitioned tables. That would be already helpful. Displaying the amount of data processed, to keep costs slim, would likely be the top thing (and Google does have API / command line in order to get the amount of bytes to be processed by a query).Detect I'm already logged in on "login" windows
I use Chrome browser. I keep multiple tabs of sisense opened. When the session expires, it expires on ALL the tabs (which makes total sense). The problem is that all those tabs get redirected to the login page and I need to login on each and every one of them. It does not detect I've logged in in another tab, neither if I hit the browser Refresh button it will detect the login and redirect me to the page I was in before I got logged out. This is annoying because I have to either login again, or open a new window and search for the dashboard I had open. Ideal expected behaviour (preferred, but probably harder): Once I'm logged out on several tabs, logging in one of them should make the others notice and log me in automatically. Good-enough behaviour ("easier"): Once I'm logged out on several tabs, logging in one of them should allow me to go to other opened tabs, which are showing the login windows, and refresh them (e.g using Ctrl+R) so that itwill automatically detect my session and redirect to the page I was before I was logged out. This will save me a lot of time and make sisense less annoying.Configurable number formatting in tooltips (instead of 12.1k show 12142)
Sisense charts show tooltips when you move the mouse above them. When showing those tooltips the website automatically formats numbers in the tooltip in order to simplify the reading and shrinks those numbers if they go above 10k. Most of the times this is what I want as a user, but not always. According to my observations, tooltips stop showing the real number and show a simplification when it goes above 10,000 (e.g instead of showing 16742 it will show 16.7k). This idea would be to allow this number to be displayed in full instead of the shrinked version. Sometimes it is just useful to see the real value and not the simplified one. As a user, I'd like to see the real one sometimes. There are two possible ways of implementing this that come to mind, in the Tooltip section when editing a graph: Add a checkbox, clickable, with the current behaviour by default "[ ] Show raw numbers". This would be below "[ ] Show Total in tooltip" Add a threshold numeric input so that users could manually specify from which number onwards the formatting would shrink (e.g 10,000 by default). "Shrink numbers above: [ 10000]" First option is simpler to understand, second one is more flexible. Right now, the workaround I'm using is to Edit a chart, then click on "Output" in order to see the real numbers as a table, but this is inconvenient. Here is an example of the number I'm referring to, in a chart. You see 15.9k and I'd like to see 15935.942Views2likes1Comment