Durch die Nutzung von AWS re:Post stimmt du den AWS re:Post Nutzungsbedingungen
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 EXPERTE
    vor 2 Jahren

    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
    vor 2 Jahren

    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
    vor 2 Jahren

    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 EXPERTE
    vor 2 Jahren

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

Themen
Analysen
Tags
Amazon QuickSight
Sprache
English
AWS-User-0067083
gefragt vor 2 Jahren67 Aufrufe
Keine Antworten

Du bist nicht angemeldet. Anmelden um eine Antwort zu veröffentlichen.

Eine gute Antwort beantwortet die Frage klar, gibt konstruktives Feedback und fördert die berufliche Weiterentwicklung des Fragenstellers.

Richtlinien für die Beantwortung von Fragen

Relevanter Inhalt