Reference data

Reply
Yellow Belt

Reference data

I have multiple datasets and cards.


In one dataset I have a beastmode where I calculate the Customer Lifetime Value.


In another dataset I use the CLV but not as a reference as I don't have the data in this new dataset.
I write the CLV hardcoded. Problem is that if the CLV changes I have to update the CLV manually in other beastmodes.

 

Is there any way to make a reference to another beastmode in some sort without having to add the CLV to every dataset and calculate it. Because that's probably too much work (and the datafile would be too large).

 

Hopefully my question is clear and I hope to see an answer.

Thanks in advance 🙂


Accepted Solutions
Black Belt

It sounds like CLV is derived from transactional data.  I assume something like SUM(SalesAmount)

to reuse CLV you could create a Dataset View (beta feature, ask your CSM) with two columns, Customer No and CLV and then JOIN it to your other dataset.

 

I think that's an inferior solution, but probably what you're currently trying to accomplish.

 

Instead create a dataset where you UNION your Customer Sales, and whatever the second Transactional dataset is.

 

This way you can keep your CLV as a beast mode, as well as visualize your other data without pre-aggregating it.


Jae Wilson
Check out my Domo Training YouTube Channel

**Say "Thanks" by clicking the heart in the post that helped you.
**Please mark the post that solves your problem by clicking on "Accept as Solution"

View solution in original post


All Replies
Black Belt

It sounds like CLV is derived from transactional data.  I assume something like SUM(SalesAmount)

to reuse CLV you could create a Dataset View (beta feature, ask your CSM) with two columns, Customer No and CLV and then JOIN it to your other dataset.

 

I think that's an inferior solution, but probably what you're currently trying to accomplish.

 

Instead create a dataset where you UNION your Customer Sales, and whatever the second Transactional dataset is.

 

This way you can keep your CLV as a beast mode, as well as visualize your other data without pre-aggregating it.


Jae Wilson
Check out my Domo Training YouTube Channel

**Say "Thanks" by clicking the heart in the post that helped you.
**Please mark the post that solves your problem by clicking on "Accept as Solution"

View solution in original post

Announcements
New & Improved Dojo: Get excited for a new feel and additional features in the online community.

Site will be down February 4-5th for maintenance.

Launch coming February 8th!