cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Regular Visitor

Filtering for Charts Help

Hi Everyone,

 

I am trying to create a bar chart that only shows information from the last 30 days (or even better having the ability to filter the chart to any month range). I have something set up currently and it is not showing anything. The error I receive is "Unexpected characters. Characters are used in the formula in an unexpected way".  The choice column I am referencing in Sharepoint is "OnHoldReason" since I want to show a chart of the reasons why something was put on hold. The sharepoint list is titled "MaterialRefill_1". Please see my code below.

 

 

AddColumns(GroupBy(AddColumns(Filter(MaterialRefill_1,Created>=DateAdd(Today(),-30,Days)),"SelectedONHOLDReason",OnHoldReason.Value),"SelectedONHOLDReason","ONHOLDReasonList"),"ONHOLDReason",CountRows(ONHOLDReasonList)))

 

2 REPLIES 2
Super User III
Super User III

@kkrushinsky 

Can you please share a screenshot of the formula with red lines?  Seeing where the dark red line helps me know where exactly the error is.

See photos below. The red underline is at the very end of the code. I also included a picture of what the chart output looks like (which is nothing basically right now).

10-12-2020 3-58-36 PM.png10-12-2020 4-00-33 PM.png

Helpful resources

Announcements
New Badges

New Solution Badges!

Check out our new profile badges recognizing authored solutions!

New Power Super Users

Congratulations!

We are excited to announce the Power Apps Super Users!

Power Apps Community Call

Power Apps Community Call: February

Did you miss the call? Check out the Power Apps Community Call here.

Microsoft Ignite

Microsoft Ignite

Join digitally, March 2–4, 2021 to explore new tech that's ready to implement. Experience the keynote in mixed reality through AltspaceVR!

Top Solution Authors
Top Kudoed Authors
Users online (19,916)