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

Forum Posts

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 7 - Data Storage
  • 15 Views
  • 1 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
  • 545 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
  • 497 Views
  • 4 replies
  • 0 kudos