By using AWS re:Post, you agree to the AWS re:Post Terms of Use
AWS re:Postre:Post

PeriodOverPeriodDifference - Returning SQL Exception

0

I have the following Calculated Field

periodOverPeriodDifference(sum(test), createdAt)

where the current output in a pivot table looks standard with createdAt as Rows and other CalculatedFields calculating the YOY Growth and Total Growth. However every time I add the above CalculatedField in I am met with a SQL Exception but I cannot see the error.

  • iwasa EXPERT
    2 years ago

    Hi.

    1. Where did you see the SQL exception?
    2. Please tell me the information of your dataset. Can you provide SPICE or Direct, reproducible sample data if possible? We can investigate the cause together.
  • AWS-User-0067083
    2 years ago

    Hi,

    The error appears as I pull the Calculated Field into the Pivot Table. At that point the chart gives the following error "Your database generated a SQL Exception, this can be caused by timeouts, resource constraints" The query is a direct query as I am not using SPICE at the moment. The data looks similar to this

  • AWS-User-0067083
    2 years ago

    createdAt YoYGrowth Sum(Test) 1/1/20 5 5 1/4/20 76 71 1/7/20 105 29 1/10/20 280 175 1/1/21 113 113 1/4/21 215 102 1/7/21 308 93 1/10/21 446 138 1/1/22 138 138 1/4/22 174 36

    Please note the orginal dates had 00:00 appended

  • iwasa EXPERT
    2 years ago

    I will give it a try. I will reply again.

Topics
Analytics
Tags
Amazon QuickSight
Language
English
AWS-User-0067083
asked 2 years ago67 views
No Answers

You are not logged in. Log in to post an answer.

A good answer clearly answers the question and provides constructive feedback and encourages professional growth in the question asker.

Guidelines for Answering Questions

Relevant content