Hi Everyone, I am very used to using PowerBI, where one way to create a dimension table, you would duplicate the table you were looking for, choose the column you wanted and then removed duplicates. This was all done in power query.I am now wondering...
Hi all,We've had feedback from customers that the right-click to drilldown behaviour on pivot-tables is not intuitive, especially for non-superuser staff. Our ideal behaviour to make it clearer would be:Row label is blue (and clearly clickable).On cl...
EDIT: Sample data-set attachedHi there, I'm working on a dashboard that needs to accurately filter inventory records based on dbt snapshot dates (dbt_valid_from and dbt_valid_to) in SiSense. I face a similar challenge to another recent user post usin...
I have a top 10 bar chart where the design options are not functioning. If I change the value label direction, X-axis options, Y-axis options, etc it has no effect at all. There is a script in the widget but has nothing to do with design. This now ap...
Hi I want to show the total task percentage i have a task count which i achieved by dupcount([Student id ]) = 337 i got the total count which is Grand total which i got by grand total option on a task which is 22,315now my formula should show 22,3...
Hi I am trying to create a formula to show the percentage of tasks Column A = Count (Pens)Column B = DupCount (Pens)Here Pens Column has Numeric ID Values like "41869 "Could you please help me with Percentage formulaThanks
Hi,This is probably a really easy fix but I have columns in my table called Shift Date, Shift Start timeI want to combine these as a custom column and then convert to a date time, but for the life of me I cannot get it to work. They are both text at ...
When I select fields in a pivot 2 table for filtering, those fields will be highlighted. If I then hover over additional fields, they get highlighted in the same color, like this:I would like to achieve 2 things in my pivot 2 tables:1. set the hover ...
Hello, I am working with a client's dashboard and trying to get a horizontal scroll bar to appear on a table widget. I have tried this code:dashboard.on('widgetready', (el, args) => { $('.p-mid', 'widget[widgetid=' + args.widget.oid + ']').scroll...
Hi Sisense Community,I'm working on an inventory dashboard in Sisense and I'm using dbt Snapshots to maintain historical inventory data. My snapshot table includes dbt_valid_from and dbt_valid_to columns to track the period for which each inventory r...
While Trying build to Destination in an elasticube model, I am getting destination viewer error. Is it related to any configuration issues and is it necessary to provide the database and schema parameter while doing Build to destination?Attaching the...
Hi Sisense team!Is it possible to add static values to a widget that would allow creation of a visual?For example, in a dashboard showing Thisyear/Lastyear month over month revenue values, how might I add a visual that shows the target revenue values...
I'm having an issue with the widget script to color the labels in a table created by @harikm007 in a previous post. https://community.sisense.com/t5/build-analytics/colored-labels-in-table-widget/m-p/10780I have successfully been able to implement th...
My visualization has the date Dec 29, 2029, which does not exist in the underlying data. This is shown, but when exporting the data, the correct date ranges are shown. Has anyone ever been able to fix this?
Hi EveryoneI have created a Calendar table based on Custom code option currently i am showing the count of records days stating from 10th to 17th but i want to show the count from dates 15th and 22ndHow can i do that
