Shulou(Shulou.com)06/01 Report--

This article shows you what the effect of setting SAP Analytics Cloud exception aggregation type to LAST is, the content is concise and easy to understand, and it will definitely brighten your eyes. I hope you can get something through the detailed introduction of this article.

The excel data sources are as follows:

If you forget to list the date of excel in SAP Analytics Cloud and set it to dimension of type Date, you cannot enable the time series forecasting feature in the drawn Line Chart:

To test the effect of setting the exception aggregation type of SAP Analytics Cloud to LAST, I created two line chart. The left one does not use any additional settings, so the sold measure uses the default SUM for aggregation operation (aggregation), and the right one uses the following settings: a calculation,measure of type Aggregation is set to sold,operation to LAST:

When the default level of line chart is 1, you can see the difference between the two settings: the line chart on the left sums the sold amount for the five months of 2019, while the line chart on the right shows the last column in dimension, the sold value of May 2019: 5.

When level = 2, do the collection in quarterly units. Q2 on the left shows the sum of sold in April and May 2019: 4 + 5 = 9, while the line chart on the right still shows the sold value of the last month, May 2019: 5.

When level = 4, the contents of the two graphs are the same.

The above content is what is the effect of setting SAP Analytics Cloud exception aggregation type to LAST. Have you learned any knowledge or skills? If you want to learn more skills or enrich your knowledge reserve, you are welcome to follow the industry information channel.

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.