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

Forum Posts

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
  • 32 Views
  • 3 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
  • 33 Views
  • 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_0-1654019798132.png
oliviar by 7 - Data Storage
  • 135 Views
  • 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 7 - Data Storage
  • 254 Views
  • 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
  • 194 Views
  • 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_0-1649101570166.png
lharrison by 8 - Cloud Apps
  • 249 Views
  • 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
  • 925 Views
  • 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
  • 402 Views
  • 2 replies
  • 0 kudos

Resolved! Remove Widget Title Box

Hello. Is there any way to remove the title portion of a widget? I often don't place a title on indicator widgets, but the title box still limits how small the widget can be and leads to some awkward white-space. Is there any way to get rid of the bo...

lharrison_0-1635965694273.png lharrison_1-1635965830967.png
lharrison by 8 - Cloud Apps
  • 1423 Views
  • 1 replies
  • 1 kudos

Building a pivot table with TY vs LY with % growth

In a pivot table where I have the year 2021 data showing, how can I show the previous years sales (depending on which year has been selected from the main dashboard) including a % growth in the following columns in the pivot?

seakins by 7 - Data Storage
  • 1010 Views
  • 4 replies
  • 0 kudos