Today I will answer a very interesting question from Anthony. Anthony need to know how many days pass from one sale to the other from a specific type of sale, lets say the sale type is [Code] field and sale date is [DATE SOLD] The table looks like that...

How to get the total out of a max aggregation?

We frequently want to compare the current month-to-date (MTD) Sales to the sales of the same period in previous month(s), rather than to the sales of entire previous months. For example, if today is the n th day of the month, we would want to compare...

How to implement exception highlighting/Conditional Formatting in the Pivot

We often receive questions from users who need to create special/custom fields. Here, I am happy to share with you the way you can convert an INT field [Seconds] into HH:MM:SS string format First, we will need to add three custom INT fields ( Hour , Min...

We just posted a new customer case study to the site, and since it is one of the coolest so far, I wanted to drop a word or two in our blog: Roy Man, the CTO of saveanalien.com , has strong opinions about web analytics. He is also in the business of saving...

This morning I discovered the existence of the Business Intelligence Index . It is a stock index of Business-Intelligence related companies published by Rick Sherman, the founder of Athena IT solutions . Rick says the index has been treading water, but...

Forrester research just published a report titled "BI Belt-tightening in a tough economic climate". In it Forrester Analyst Boris Evelson discusses the role of business intelligence in tough economic times. "As an economic downturn becomes...

Working and founding a business intelligence company means that you (a) belong to the analytics-obsessed (b) when obsessively analyzing your own business you begin to eat your own dog-food. This is entirely the case with our AdWords campaigns: we pore...

Well, back in December we announced the SiSense Dashboard Competition. We're pleased to announce we have a winner: Mahmoud Wardany of Madar Holding in the UAE. Here's the winning dashboard: A few words from our winner about the dashboard and its...

Have you ever wanted to see how many times a value appears in the data, so you casually dropped the 'Value' dimension onto the rows panel of a pivot widget and the 'Count Value' measure onto the columns panel and get the value '1'...

Have you ever wanted to give your viewers the possibility to filter a widget with a single click? Somewhat like the image below, that lets a user click on either the Best Selling Products or Least Selling Products and see the appropriate products in the...

Some of you may have probably noticed that apart from sheets, a Prism document may also contains 'questions'. Unlike a sheet that is used to visualize data, a question is a special type of canvas used to visually create filters and segment data...

Sometimes, data in an Excel file is not structured ideally to be imported by Prism. Occasionally, the data is presented in a Pivot-like manner that is more readable and takes up less storage space. A good example for this is marketing survey data that...

Dennis Howlett quotes Sun Microsystems' Tim Bray on surviving the tough economic times . John Doerr lists ten points for companies to stay afloat on Venture Beat . Being frugal has become hip, there's no doubt about that. Both people quoted above...