Pixel-Perfect report repeating sections unexpected behaviour

[Valentin]

Hi!

I have encountered some strange behaviour using repeating sections in Pixel-Perfect report.

Just for you to understand what I’m trying to do.
I have created parameter some_parameter and calculated field like:
ifelse(
some_attribute = ${some_parameter},
other_attribute,
‘no_attr’
)
Then I added this calculated field as repeating dimension, so when I choose parameter →
i get iteration in dimension by values only for some_parameter.

So, to the issues:

1. When I have created a table to see what’s the data I have inside repeating section and I got “No data”:
   
   

But, suddenly, when I changed format to pivot table I got my data (cannot show it here, unfortunately).
I don’t think that’s an expected behaviour.

2. How can I exclude some value from dimension iteration?
   Like in my case I still have ‘no_attr’ value, but I don’t want iterate through it.

3. I have created a quicksight simple line chart with my data and was fine:
   

   

But I needed vertical reference line, so I tried to create this simple line chart with highcharts and got this:

When I tried to create the same chart outside repeating section (section_1) in the same Pixel-Perfect report I got the chart I was expecting (of course I have changed filters in section1 so it matches the repeating section):

my highchart JSON representation looks like this:

{
  "xAxis": {
    "type": "datetime",
    "min": 1724467200000,
    "max": 1744281600000,
    "plotLines": [{
            "color": "#FF0000",
            "width": 2,
            "value": 1729467300000
    }]
  },
  "series": [
    {
      "type": "line",
      "data": ["getColumn",0, 1],
      "name": "value"
    }
  ]
}

Thank you for your help!

[Brett]

Hi @Valentin,
Thank you for taking the time to break down your situation, could you please clarify what your question is though regarding this scenario?

Thank you

[Valentin]

Hi

In this regard for points 1 and 3 the questions is: is it a bug or expected behaviour for repeatable sections?
So, what can I do to fix this?
I also think that you should know about such things.

Point 2 is not relevant now, sorry, I assume I can just filter the dimension field and it should work.

Thank you for your answer!

[Brett]

Hi @Valentin,
Apologies for missing your last reply, In future instances, I would suggest tagging the person whom you are replying to so that they get notified of a response!
In terms to repeating sections, have you reviewed this article published by Amazon that explores repeating sections a bit more in depth?

One thing sticks out to me specifically under the ‘Key Considerations’ section:
“Another key factor to consider is that if a specific combination of values for a dimension in a repeated section doesn’t have any corresponding data, any charts or tables within that repeated section iteration will show “No Data” instead of visualizations.”

I wonder if that has something to do with why you’re receiving the ‘No Data’ response in certain instances. Highcharts still have limitations as well so they may not work properly with repeating sections, which may be leading to why you’re not getting the full amount of data on that option.
But if you’re getting different results depending on the type of visual you’re utilizing, this may be a bug and in that instance, I would suggest creating a support ticket to see if AWS support can help you more in depth.

Let us know if you’ve found a work around for your case in the interim, or if you have any additional questions. If we do not hear back within the next 3 business days, I’ll close out this topic!

[Brett]

Hi @Valentin,
Since we have not heard back, I’ll go ahead and close out this topic. However, if you have any additional questions, feel free to create a new post in the community and link this discussion for relevant information if needed.

Thank you!