Skip to main content

Notifications

Announcements

No record found.

Customer experience | Sales, Customer Insights,...
Suggested answer

Creating measures in customer insights

(1) ShareShare
ReportReport
Posted on by 5

Hi, I'm trying to create a measure with the next atributes: the average purchase amount of the clients minus the average purchase amount in total. I'm having problems because when I try to rest these two measures one or another does not appear, and I think it is due the different dimension of these two measures, the first is at customer level and the second is at business level. 

  • Pablo Martin Profile Picture
    Pablo Martin 5 on at
    RE: Creating measures in customer insights

    Hi Cristina:

    You cannot use a Business Measure (average purchase amount in total) in the calculation of a Customer Measure or Customer Attribute through the UI. If you try to force it, it will tell you that you are missing the Customer Id field in the Business Measure.

    Have you tried using the SQL interface to build it?

  • Cristina.landa Profile Picture
    Cristina.landa 5 on at
    RE: Creating measures in customer insights

    I have both of them created as different measures one in the customer_measure entitie and the other in a new entitie that was created when I did the measure of average pruchase amount (all)  , the problem is that it does not let me put both of them in the same measure to do the subtraction. I think because one is at customer measure and the other a business one.

    Thank you so much!

  • Suggested answer
    Bill Ryan Profile Picture
    Bill Ryan 803 on at
    RE: Creating measures in customer insights

    If I understand the question correctly, you want to subtract Average Purchase Amount (record) by Average Purchase Amount (all) .  If you created an Average Purchase Amount All, it should show up as a Measure (make sure it is defined as a Business Measure). When you're using the Segment builder, make sure you select the Measures tab vs the Attributes tab, I think that's what's causing your issue. If that doesn't work you may need to use the SQL Measure builder

    MeasuresSample2.pngMeasuresSample.png

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 Verified Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

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

#2
Martin Dráb Profile Picture

Martin Dráb 230,445 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans