Oracle Analytics Cloud and Server

Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture

Historical overview

Received Response
11
Views
3
Comments
Mirna Sevilla
Mirna Sevilla Rank 3 - Community Apprentice

Summary

Historical overview

Content

I have a table similar to the one below. I would like to show progress overtime. For example, has the number of customers increased or decreased? same for ARR. Any idea how to do it?

I like the use of colored arrows to show progress (see below), but a chart is also an option.

I am quite new to the DVD world, thus your help is greatly appreciated.

Answers

  • 1139587 wrote:I have a table similar to the one below. I would like to show progress overtime. For example, has the number of customers increased or decreased?

    Increased or decreased compared to what? If you create an AGO measure like "Customer Count Week Ago" then you can compared the current to the previous value. But you have to have a comparison measure of some sort first.

  • 1139587 wrote:Increased or decreased compared to the same data from a previous period. I will try your suggestion. Thanks Christian

    So as I hinted: time series functions: Modeling Time Series Data

  • Mirna Sevilla
    Mirna Sevilla Rank 3 - Community Apprentice

    Increased or decreased compared to the same data from a previous period. I will try your suggestion. Thanks Christian