• Total activity 50
  • Last activity
  • Member since
  • Following 1 user
  • Followed by 1 user
  • Votes 24
  • Subscriptions 16


Recent activity by Yonatan Sort by recent activity Recent activity Votes
  • Changing the ‘Grand Total’ label on pivot table

    *****Windows Only**** When having a pivot table which contains more than one value and present the grand total for each of the values, the total row is called “Grand Total”   In some cases you can ...

  • Cumulative Count Distinct

      Analytical Need  In some cases, you would like to count the number of unique entities that did a certain action/transaction. For example, how many individuals entered my store last month and purc...

  • Forecasting by Historical Performance

     Analytical Need  While tracking your sales performances during the quarter and compare it with the quarterly target, wouldn’t be helpful if you’ll have an indication for your current pace and whet...

  • Switch Between Metrics

     Analytical Need  There are many cases when we will want to measure a metric by a different angle or definition. For example, in some cases you would like to allow your end users to analyze average...

  • The Funnel Analysis

     Analytical Need ‘Funnel analysis’ describes process flow, where in its beginning the number that we measure is relatively big, and in each step within the process this number is getting smaller al...

  • Alert on a M2M Risk

    Introduction This article describes how to enable an alert* when there is a risk of Many-To-Many relationship (M2M) between two or more tables. * This implementation involve the use of Pulse and i...