Spotfire Ideas Portal
Add a new idea Subscribe
Status Future Consideration
Product Spotfire
Categories Custom Expressions
Created by Guest
Created on Apr 19, 2017

RELATED IDEAS

Lastperiods() with negative period numbers

Hi,

The lastperiods function can only accept positive first parameter (which indicates the number of periods to include in the calc (as opposed to the previousperiod function which can take negative arguments). if you tried to use this function in a visualization that is ordered descending by time, but would like to sum the next n periods (which would be the last n if the ordering was ascending) you simply can do it. (Of course there is a workaround by creating a calculated column.)

Thanks,

Laszlo

  • Attach files
      Drop here to upload
    • Guest
      Reply
      |       Feb 27, 2020

      Thanks for pointing this out. Please consider using NavigatePeriod as well.

    This document (including, without limitation, any product roadmap or statement of direction data) illustrates the planned testing, release and availability dates for Spotfire products and services. It is for informational purposes only and its contents are subject to change without notice. Planning to implement - generally 6-12 months out. Likely to Implement - generally means 12-18 months out. Copyright © 2014-2023 Cloud Software Group, Inc. All Rights Reserved. Cloud Software Group, Inc. ("Company") follows the EU Standard Contractual Clauses as per the Company's Data Processing Agreement. Terms of Use | Privacy Policy | Trademarks | Patents | Contact Us