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 7 - Data Storage
  • 34 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
  • 40 Views
  • 0 replies
  • 1 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
  • 67 Views
  • 1 replies
  • 0 kudos

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
  • 34 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

The script Waterfall  doesn't work anymore

Hi all, Do you notice that the script Waterfall doesn't work anymore after the release L2022.09 or L2022.10 ? The summary columns are not calculated and the "layout" don't work. The console give this error message : "Cannot set properties of undefine...

Claire by 7 - Data Storage
  • 47 Views
  • 0 replies
  • 0 kudos

Bubble Chart with Pivot

Hi all, I want to make bubble chart inside the Pivot table, we have column as a Product Category and rows as an ID, I want to show bubble as a value between them. For Example: I want bubble instead of Total Profit% value inside the pivot table. Pleas...

Bubble Chart Inside Pivot Table

Hi all, I want to make bubble chart inside the Pivot table, we have column as a Category and rows as an ID, I want to show bubble as a value between them. Please help. Thanks

Gamification

I'm started planning for the gamification of our software. I'm starting with Bartle's Player Types (I'm an EAKS, no surprise there) and am assuming that the best way to go about this as a dashboard widget is going to be BloX for the original graphics...