• Total activity 151
  • Last activity
  • Member since
  • Following 0 users
  • Followed by 0 users
  • Votes 0
  • Subscriptions 107

Activity overview

Latest activity by Samya
  • Samya created an article,

    Using Libraries to share data between Applications

    Librairies allows you to use Blocks'data coming from other Applications. Here are the steps you need to follow :              Activate the sharing of a Block               Activate the library in y...

  • Samya created an article,

    PREVIOUS function

    Description Previous is an iterative computation that allows filling the cells with the previous value following a specific dimension (generally a time dimension). The function references anothe...

  • Samya created an article,

    ADD modifier

    Description Returns an object (metric or property) with more dimensions. Syntax source_property[ADD: dimension1, dimension2, ...]source_metric[ADD: dimension1, dimension...

  • Samya created an article,

    Exploring your model with the Dependency Diagram

    The Dependency Diagram shows your application an overview of a model's structure. It enables you to understand the data flow of a specific Block by showing source and target Blocks (Metrics and Tra...

  • Samya created an article,

    Play with formulas using the Formula Playground

    The Formula Playground is a tool that allows you to test your formulas without constraint of types or dimensions.              How is Formula Playground different from Metric Block?           How t...

  • Samya created an article,

    Upload data from Google Sheets

      Pigment's GSheet Connector can be set up to push data from Google Sheet directly into Pigment. The setup is composed of 3 main parts: Add the Pigment script Set up triggers Configure exports Ad...

  • Samya created an article,

    Waterfall charts

      → also called Bridge chart A waterfall explains the variation between 2 situations. It's useful for understanding how an initial value (for example, Budget) is affected by a series of positive an...

  • Samya created an article,

    Comparing data with Calculated Items

      In Tables or Metrics, using a Calculated Item allows you to add a calculation using data from specific items within a dimension. Illustrative example: I want to calculate the absolute difference ...

  • Samya created an article,

    Using Conditional formatting to highlight information

    Conditional formatting helps you visually explore and analyze data, detect critical issues, and identify patterns and trends. It makes it easier to highlight interesting cells or ranges of cells, e...

  • Samya created an article,

    Using the Blocks Explorer

    The Blocks Explorer is a file manager and it allows: Searching blocks (Metrics, Tables, Dimension and Transaction lists) Browsing folders Copying and deleting blocks     How to access the Blocks...