How to add constant value to graph? OR UX Chart has multiple data sources?

I am trying to build out a UX dashboard for a module that contains a list of products and imported data that shows how much resources each product uses(the resources is defined by one single number per month). In another module I have a specific line item that contains our total max resources (number). I am trying to create a UX chart that has all the data from module 1 but I want to impose the single line item data from module 2 that shows the resource capacity. So basically I am trying to create a graph that combines the data from two modules Is this possible at all?

Accepted answers

All comments

KirillKuznetsov

Hi @davargas

No, you cannot connect multiple modules but you can achive the desired by creating additional line item in the source module of the graph.

davargas

Hey @KirillKuznetsov, thank you for your response. Creating an additional line item still doesn't do the trick for me but I thought of another solution that could work, so long as it exists lol. The source model for the UX page I am building (D03) is dimensioned by Pages: Locations, Resources Groups, Teams, and Version. Columns: Time. Rows: Product Names, and one line item "Slots" which are our resources. In the Product Names list, there are items called CAPACITY that are empty. I was thinking a solution that could work for my case would be to write a formula for "Slots" that essentially does an IF ELSE THEN statement, but the boolean would check the names for each item in Product Names list. I am trying to accomplish something like this:

IF NAME('CAPACITY') THEN 'D02 Planned Capacity'.Corrected Capacity ELSE 'D01 Slot Forecast'.Slots

I feel I am either fairly close or completely far off. Thank you for your help!

ryan_kohn

@davargas Per @KirillKuznetsov's this should be solvable by adding another line item to Module 1 that points to your max capacity from Module 2. Here's an example that I mocked up.

Blueprint for the data module:

Let us know if this approach doesn't work for you.

davargas

Hey @ryan_kohn Thank you for the response. I ended up figuring it out a different way. However, I am stuck on another problem if you would like to give input. See https://community.anaplan.com/t5/Anaplan-Platform/Referencing-List-Items-in-Formula/m-p/143214#M38211 for reference

ryan_kohn

@davargas Glad you figured out a solution! Would be great if you could share your solution here so we can all learn from it!

KirillKuznetsov

@ryan_kohn

thanks for your contribution! I didn't have a chance to implement the example.

@davargasPlease share your solution, very curious!

Quick Links

Can you help?

Unanswered questions

import monthly data with months in columns
is there a way to import data with months in columns (usual excel table view)? I have to transform the data so there are rows to cover each period in the upload data form, but I am wondering if there is a better way to just import the data as is with the months in the columns. please let me know what you think. thank you,
Cloudworks Big Query Integration Fail
Hello, I am receiving an 'Anaplan Upload Failed' Status Description when testing my integration with a Big Query dataset. The integration imports data from BQ to our Anaplan model. No other details given in the error log. I suspect that Cloudworks is not even picking up the file but am not sure what we did wrong on the set…
Looking for Anaplan End-Users to take a short survey!
We are looking for Anaplan end-users to provide feedback on their experiences with the Excel add-in. Interested individuals will respond to this 5-minute survey to help us understand personal needs and behavior when using the add-in. The feedback provided by survey takers is essential to the roadmap of Anaplan's products.…