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

line chart and column chart in power app

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...

 

i want to make line chart which will tell the  no. of interview happened on week basis.
and one colums chart which will tell the the selected and not selected count.

 

someone please tell how to write the function to get the required line and colum chart.


please help.

Images are attached.

thnaks

1 ACCEPTED SOLUTION

Accepted Solutions
Sunil-Narnaware
Solution Supplier
Solution Supplier

@aadi_0453 : This is how your table shaping function would look like.. Replace colInterviewStatus with your interview details data source table and rename with appropriate column.. 

 

ClearCollect(
    colNewInterviewStatus,
    AddColumns(
        GroupBy(
            SortByColumns(
                AddColumns(
                    colInterviewStatus,
                    "Week #",
                    WeekNum(ThisRecord.InterviewDate)
                ),
                "Week #",
                Ascending
            ),
            "Week #",
            "NewGroup"
        ),
        "No. of Interviews",
        CountRows(NewGroup),
        "No. of Selected",
        CountRows(
            Filter(
                NewGroup,
                Progress = "Selected"
            )
        ),
        "No. of Not Selected",
        CountRows(
            Filter(
                NewGroup,
                Progress = "Not Selected"
            )
        )
    )
);

 You can write the above code on 'OnVisible' Property of your Screen.. Make sure to set the Charts' Items property to colNewInterviewStatus the collection where the result of table shaping is stored..

 Here is the end result I got at my end..

 

SunilNarnaware_1-1656614737243.png


=================================
If this solves your problem, 'Accept is as Solution' so others can also benefit from it. If you like, hit 👍.

 

View solution in original post

5 REPLIES 5
Sunil-Narnaware
Solution Supplier
Solution Supplier

@aadi_0453 : This is how your table shaping function would look like.. Replace colInterviewStatus with your interview details data source table and rename with appropriate column.. 

 

ClearCollect(
    colNewInterviewStatus,
    AddColumns(
        GroupBy(
            SortByColumns(
                AddColumns(
                    colInterviewStatus,
                    "Week #",
                    WeekNum(ThisRecord.InterviewDate)
                ),
                "Week #",
                Ascending
            ),
            "Week #",
            "NewGroup"
        ),
        "No. of Interviews",
        CountRows(NewGroup),
        "No. of Selected",
        CountRows(
            Filter(
                NewGroup,
                Progress = "Selected"
            )
        ),
        "No. of Not Selected",
        CountRows(
            Filter(
                NewGroup,
                Progress = "Not Selected"
            )
        )
    )
);

 You can write the above code on 'OnVisible' Property of your Screen.. Make sure to set the Charts' Items property to colNewInterviewStatus the collection where the result of table shaping is stored..

 Here is the end result I got at my end..

 

SunilNarnaware_1-1656614737243.png


=================================
If this solves your problem, 'Accept is as Solution' so others can also benefit from it. If you like, hit 👍.

 

aadi_0453
Regular Visitor

Hi @Sunil-Narnaware ,thanks it worked.

@aadi_0453 , you can also create a beautiful power BI report with many visualizations and then use that power bi dashboard/ report with power app fully intuitive .

aadi_0453
Regular Visitor

hi @Kumar_PA, thanks i will try it.

@aadi_0453 but do remember you have to consider delegation when working with large amount of Data.. https://docs.microsoft.com/en-us/power-apps/maker/canvas-apps/delegation-overview

Helpful resources

Announcements
Super User 2 - 2022 Congratulations 768x460.png

Welcome Super Users

The Super User program for 2022 - Season 2 has kicked off!

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.

<
Users online (2,545)