Issue with Pie chart

[AntoineOA]

Hello,

I am facing a problem with a pie chart. I build this screen  one year ago and it was working perfectly until yesterday. I didn't touch anything but the pie is not showing. Here is the visual I'm suppose to have  on left and what I have now on right: 

The code I am using is this one : 

SortByColumns(
    AddColumns(
        GroupBy(
            Filter(
                CRA_CRA,
                UserId = _userDomain And InputDate >= _startDateAnalytics And InputDate <= _endDateAnalytics And Not ("XX" in ThisRecord.WBS)
            ),
            "WBS",
            "TypeGroup"
        ),
        "Total Work",
        Sum(
            TypeGroup,
            Work
        )
    ),
    "Total Work",
    SortOrder.Descending
)

Thank you in advance.

[KeithAtherton]

Hi @AntoineOA,

A few things to check:

• If you resize or re-position the pie chart control, does it show? (In case it is currently minimized.)
• Does the pie chart control have Visible property set to true?
• If you select your code in the formula bar, can you see a table of results?
• If you recreate the pie chart control and use the same data source, does it show?
• If you recreate the pie chart control and use a different data source, does it show?

---

If I have answered your question, please mark your post as Solved.
If you like my response, please give it a Thumbs Up.
Follow me online.

[AntoineOA]

Hi @KeithAtherton , 

• I tried to re-position the pie chart and nothing happened. 
• I do have visible property. It's the first thing I checked here. It's on true but it's still invisible.
• I do no have a table of result. I only see it when I reduce the code to this : 

Filter(
      CRA_CRA,
       UserId = _userDomain And InputDate >= _startDateAnalytics And InputDate <= _endDateAnalytics And Not ("XX" in ThisRecord.WBS)
            )​

• If I create a pie chart, the PieChartSample works. But my code was working nicely during months so it's strange that nothing showing here.
• Yes it's working with an other data source. The code is the problem but I don't know why.

[KeithAtherton]

Checking those helps narrow down the issue.

The image of the original, working pie chart shows values for "Total Work" but the new, not-working pie chart has blank values for "Total Work". I suspect "Total Work" is used in the pie chart and having blank values means nothing can be displayed.

Seeing as "Total Work" is a sum of CRA_CRA.Work, can you see values existing for the date range you're using?

---

If I have answered your question, please mark your post as Solved.
If you like my response, please give it a Thumbs Up.
Follow me online.

[AntoineOA · Accepted solution]

Hello  @KeithAtherton , I found the solution by adding ThisRecord before Work in the sum function. Thank you for you help! 😄 

[KeithAtherton]

Great news, well done! Thanks for the update.