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

Forum Posts

Widget to display time

Hi, We have a requirement where we have to display the local timezone of the country that is being selected from the dashboard filter. The dashboard filter on country has values like Italy, France, Netherlands, UK, US etc. When the user selects "Ital...

R1 by 7 - Data Storage
  • 5 replies
  • 0 kudos

Apply a Formula to Select Rows in a Pivot Table

I have a pivot table and I'm pretty happy with how it looks. However, I want to adjust the formula in two of the columns, if possible.The pivot table looks like this: There is a formula in 2 of the value columns: LTD Remaining to Goal, and Forecasted...

oliviar by 7 - Data Storage
  • 1 replies
  • 0 kudos

Resolved! Overlapping Column Chart

I am looking at a Goal vs. Actual column chart. I have two context cases for this framework: units goal and units sold, and revenue goal and revenue collected.I have my bar chart working correctly, but I want to change the design of it a bit to be mo...

oliviar_0-1657051095250.png oliviar_1-1657051261075.png
oliviar by 7 - Data Storage
  • 5 replies
  • 0 kudos

The Houdini Report

We are finally releasing our Analytics Suite to our customers and I would like to create a Dashboard/Report to specifically show items that have "Disappeared" from weekly sales. If an item was consistently sold for 3 weeks or more and then 3 weeks go...

NexGenDSD by 7 - Data Storage
  • 0 replies
  • 0 kudos

Resolved! How to Calculate YTD by Month in a pivot table

I have a pivot table that works for my team. It looks like this: The variance column is a simple formula showing the difference between Budget and Revenue (Revenue - Budget). I have received a request to expand this pivot (or create a new one based o...

oliviar by 7 - Data Storage
  • 2 replies
  • 0 kudos

Resolved! Edit Widget Script Sisense to display NA for specific condition

I want to add a custom script for my widget using this option I have a calendar filter on my dashboard like below   It is being carried forward to the widget like so   Our fiscal year is Oct to September.Now, my requirement is that whenever user sele...

image1.png image2.png image3.png image4.PNG
Lisha by 8 - Cloud Apps
  • 6 replies
  • 0 kudos

Resolved! How do I sum if or count if using conditional values?

Hi Community, I'm trying to figure out why my pivot table is returning incorrect values, and how to fix it.I need a variety of formulas that apply to each program in my pivot table to collect data about how much money we are contracted to receive, ho...

oliviar_7-1652199331670.png oliviar_8-1652199384350.png oliviar_1-1652198307796.png oliviar_2-1652198431447.png
oliviar by 7 - Data Storage
  • 3 replies
  • 0 kudos

Resolved! Year-To-Date for Only Completed Months

Hello, I have a pivot table where I am calculating YTD vs. LYTD metrics by month, like this: I want to exclude April from this table as it is not a completed month and thus doesn't provide useful information. I can't figure out how to do that from th...

lharrison by 8 - Cloud Apps
  • 2 replies
  • 0 kudos

Using answer to a calculation within another calculation

Im looking to use the answer from one calculation in another calculation on a separate widget with different filter set up. This is my first calculation, it counts how many sales we have prior to drafting for each model and divides by the total numbe...

CLewis_0-1643412425107.png CLewis_1-1643413787436.png
CLewis by 8 - Cloud Apps
  • 4 replies
  • 0 kudos

Resolved! Ceiling Calculation

Wondering if any knows a way to use the ceiling calculation to round to the nearest 1000? I am trying to recreate this Excel calculation. =CEILING(P4,1000)-100 P4= $379,083.04 answer should be $379,900

CLewis by 8 - Cloud Apps
  • 2 replies
  • 0 kudos