ONYX REPORTING LTD.
  • Welcome
  • Services
  • Blog
  • YouTube Channel
  • Contact
  • Domo IDEA Exchange
    • Schedule
    • Call for Presenters
  • Welcome
  • Services
  • Blog
  • YouTube Channel
  • Contact
  • Domo IDEA Exchange
    • Schedule
    • Call for Presenters
Search

Date Magic with Excel and Jet Reports (part II)

9/9/2015

0 Comments

 
Welcome back to Part II of Date Magic with Excel and Jet

In Part I, we looked at using Excel DatePart functions to create date filters for our reports.  I find this technique most useful for Operational and Sales reports as well as Income Statement reports.

True story: I worked with a client in manufacturing to develop, schedule and distribute over 200 key reports using these techniques.  He loved it because users would stop coming to his desk asking "what were our numbers for ..."; because, he could always reply, "The report is in your inbox."

As clients turn their gaze toward Balance Sheet Reporting or analysis across time, we often find it beneficial to conduct Month over Month comparisons or leverage the Accounting Periods from NAV. To quickly generate our date ranges we'll take advantage of the [Accounting Period] table in NAV or the logical [Date] table..  This technique is downright invaluable for my manufacturing and retail clients who use 4 week periods or a 4/4/5.  

If you want to automate your Jet Reporting.  Download our Sample Report

H/T to Jet Reports Guru @Janice Taylor at Jet Reports Canada for co-authoring this document.

0 Comments

Your comment will be posted after it is approved.


Leave a Reply.

    Profile Picture Jae Wilson
    View my profile on LinkedIn

    Stay Informed.

    * indicates required

    RSS Feed

    Categories

    All
    Automation
    Basic Training Series
    Business Intelligence
    Connect
    Dashboard
    Data Pipeline
    Data Science
    Domo
    Excel Tricks
    Executive Training & Leadership
    Extract
    Jet Enterprise
    Jet Essentials
    New Release
    NP Function
    Onyx Reporting
    Planning
    Power Pivot
    Python
    Report Writing
    Statistics And Analytics
    TimeXtender
    Visualization

London, UK
jae@OnyxReporting.com
+44 747.426.1224
Jet Reports Certified Trainer Logo
  • Welcome
  • Services
  • Blog
  • YouTube Channel
  • Contact
  • Domo IDEA Exchange
    • Schedule
    • Call for Presenters