Build Analytics
cancel
Showing results for 
Search instead for 
Did you mean: 

Forum Posts

Showing last 12 months based on end date

Hello! I'm struggling to build the following logic for my report: I need to show last 12 months data based on time frame selected. For example, if the user selects 04/2021 - 09/2022 time frame - the chart should only show 12 months before 09/2022. An...

Screenshot 2022-12-06 at 13.52.33.png
dim4a91 by 1 - New Member
  • 13 Views
  • 0 replies
  • 0 kudos

Deselect stacked Column chart legend value by default

Hi, I'm looking for help deselecting a stacked Column chart value by default. Use case: I have a stacked column chart stacking a metric (# of Actions suggested) by date. Lets say I have 4 actions: Run, Hide, Fight, and No Action - over 90% of my data...

Gramsey by 7 - Data Storage
  • 18 Views
  • 0 replies
  • 0 kudos

Passing Date Filter into Pivot Formula

Hello! I was wondering if anyone has passed in a date parameter into a Pivot Table Formula before. If so, how best can I accomplish this? I have a begin count of employees and end count. There is a count for every day and this report can be run off o...

mbottai_1-1670010877294.png mbottai_0-1670010851158.png
mbottai by 7 - Data Storage
  • 42 Views
  • 1 replies
  • 0 kudos

New Blox Border Snippet

I cannot figure out where in the editor to place the border snippet code to keep my blox widget from using the system defaulted corner radius. No matter where I place it the corners of the widget remain rounded. { "spaceAround": "none|small|medium|la...

Last build time of a live data model

Hi, How do i access and use the last build time of a live data model in my widget script. The following code doesn't give me the last update/build time. var lastbuildtime=w.dashboard.lastBuildTime Regards, R

R1 by 7 - Data Storage
  • 16 Views
  • 0 replies
  • 0 kudos

RSUM with Display Missing as Zero and BreakBy

I got ahead of the user on this one...Solved: RSUM with Display Missing as Zero - Sisense Community...and found out only after getting a great solution that the user has a field in the Break By. Anyone gracious who can expand the script to work over ...

wallingfordce_0-1669833150334.png

Retrieving previous rows data in Sisense Data Modeling

Hello all, I have a requirement where we need to get the value of last row's ending balance as beginning balance of the current row and this process should carry on for next 100 rows. And we don't have any base table for this and everything is build ...

adityak by 7 - Data Storage
  • 18 Views
  • 0 replies
  • 0 kudos

Dynamic date display in text widget

Hi, I'm trying to display the timezone of the country based on the value selected in the country dashboard filter, in a text widget. Using the below dashboard script as kindly shared by a fellow community member, but I don't see date getting populate...

Screenshot 2022-11-29 at 10.50.23 AM.png Screenshot 2022-11-29 at 10.49.06 AM.png
R1 by 7 - Data Storage
  • 48 Views
  • 1 replies
  • 0 kudos
Community Toolbox

Recommended quick links to assist you in optimizing your community experience:

Need additional support?:

Community Support Request