Skip to main content

Notifications

Announcements

No record found.

Microsoft Dynamics 365 | Integration, Dataverse...
Answered

Can kind of personalized dashboard be created

Posted on by 80

Hello dear collegues,

Is there any way to create kind of personalized view or dashboard to see activities which were create

before and after proposal (date is in the record field) on specific opportunity which can be selected.

Thanks,

Bohdan

  • Wahaj Rashid Profile Picture
    Wahaj Rashid 11,319 on at
    RE: Can kind of personalized dashboard be created

    Hi Bohdan,

    To make it easier for other readers, can you please mark the suitable answer as verified:

    pastedimage1609909445059v1.png

    Best,

    Wahaj

  • Bohdan_Y Profile Picture
    Bohdan_Y 80 on at
    RE: Can kind of personalized dashboard be created

    Thank you, it looks pretty close to the solution I was looking for but Wahaj is right and I can`t compare two dates.

    Best regards,

    Bohdan

  • Verified answer
    Wahaj Rashid Profile Picture
    Wahaj Rashid 11,319 on at
    RE: Can kind of personalized dashboard be created

    Hi,

    Thank you for your query.

    You cannot compare two date fields in the View Criteria (or Advanced Find).

    To elaborate, Activity.CreatedOn<Opportunity.ProposalDate kind of expressions are not supported within CRM views.

    You have following options to achieve this:

    • If you are using On Premise, create a SSRS report and do this comparison in SQL Query.
    • For online, either use Power BI or other BI tools. You may export your data to a datawarehouse for such analysis.
    • Another simple approach is to export data to Excel (Activities along with Opportunities) and make a Pivot. You can use Dynamic Worksheets to have the latest data always.

    Let me know if you need further clarification.

    Best,

    Wahaj

  • Verified answer
    Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Can kind of personalized dashboard be created

    Hi Bohdan,

    What you need is show personalized view or dashboard of activities based on opportunity, right?

    You can go Settings > Customization > Customize the system > Entities > Activity > Views to create a new view.

    Add columns of activity entity you need firstly, and ‘Regarding’ field is must.

    Then select ‘Regarding(opportunity)’ in record type, add fields of opportunity entity you need.

     pastedimage1609815281429v1.png

    click ‘Edit Filter Criteria’ button to set filter to make the view just show activities that regarding type is opportunity.

    pastedimage1609815439349v2.png

    save and publish all customization, go to the view and select you just crested, the view will show records that regarding type is opportunity.

    pastedimage1609816001121v3.png

    if you want to show records based on one specify opportunity, you can expand 'topic(Regarding)' column and click filter by to insert opportunity name you need.

    pastedimage1609816214770v4.png pastedimage1609816309114v5.png

    and you can add the view you created to the dashboard, but if you want to filter column in dashboard, you need enable editable control.

    pastedimage1609816655204v6.png

    Regards,

    Leah Ju

    Please mark as verified if the answer is helpful. Welcome to join hot discussions in Dynamics 365 Forums.

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Tips for Writing Effective Suggested Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,280 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,235 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Product updates

Dynamics 365 release plans