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

filter the table excel data of last month and show the pie chart of selected, not selected etc of progress columums

table info:

emp_name ,  Progress   , InterviewDate

ankit    ,    Not select,   22-01-2000

aman,  selected,   23-01-2000

sahil,  canceled,   28-01-2000

atul,   removed,   09-02-2000

sandeep  , selected,   12-02-2000

raman,   notselect,   15-02-2000

avi,     selected,   28-02-2000

etc...

 

want to create 3 piechart.

1.i want to make pie chart of all time data.

2.for last month data,  pie chart

3. for last week data,  pie chart

 

1. for all time data Its working by putting in the piecharts item.

AddColumns(GroupBy(AddColumns(Table_query,"name1",Progress),"name1","Progress"),"Number",CountRows(Progress)) 

 

2. for last month data, i am trying to filter data for last month using 

Filter(Table_query, InterviewDate>=DateAdd(Today(),-30,Days)) , in the item of piechart , its filtering the data, but facing issue to use both filter and above query together.

 

 

how to combine both filter and addcloumns query.
Filter(Table_query, InterviewDate>=DateAdd(Today(),-30,Days))

and 

AddColumns(GroupBy(AddColumns(Table_query,"name1",Progress),"name1","Progress"),"Number",CountRows(Progress)) 

 

in one single query.

or any other way to do it.

please help!
thanks.

 

 

 

3 ACCEPTED SOLUTIONS

Accepted Solutions
WarrenBelz
Super User
Super User

Hi @aadi_0453 ,

I am a bit confused why you are adding columns to group with the same names that are there already - you may want this

AddColumns(
   GroupBy(
      Filter(      
         Table_query,
         InterviewDate >= DateAdd(Today(),-30,Days)
      ),
      "Progress",
      "Data"
   ),
   "Number",
   CountRows(Data)
)

 

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

Visit my blog Practical Power Apps

View solution in original post

aadi_0453
Regular Visitor

hi @WarrenBelz , Thanks it worked.

View solution in original post

Hi @aadi_0453 ,

Sorry, I do not use charts in Power Apps very often, so am probably the wrong person to ask.

View solution in original post

4 REPLIES 4
WarrenBelz
Super User
Super User

Hi @aadi_0453 ,

I am a bit confused why you are adding columns to group with the same names that are there already - you may want this

AddColumns(
   GroupBy(
      Filter(      
         Table_query,
         InterviewDate >= DateAdd(Today(),-30,Days)
      ),
      "Progress",
      "Data"
   ),
   "Number",
   CountRows(Data)
)

 

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

Visit my blog Practical Power Apps

aadi_0453
Regular Visitor

hi @WarrenBelz , Thanks it worked.

aadi_0453
Regular Visitor

hi @WarrenBelz ,
with same data i want to make a line chart with weekly data.
on date basis, for last 4 weeks.
on y-axis i want to make no. of interview

on the x-axis i want to show week.
i have attached the pic, somthing like that i want show in the chart.

so i am little confused how i will count the data week wise.
or how can i add a colum which will contain the week count.

 

Hi @aadi_0453 ,

Sorry, I do not use charts in Power Apps very often, so am probably the wrong person to ask.

Helpful resources

Announcements
Power Platform Conf 2022 768x460.jpg

Join us for Microsoft Power Platform Conference

The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.

365 EduCon 768x460.png

Microsoft 365 EduCon

Join us for two optional days of workshops and a 3-day conference, you can choose from over 130 sessions in multiple tracks and 25 workshops.

Users online (3,550)