To display a Text message in the dash board based on the Variance

Hi,

To display a Text message in the dash board (Separate Grid not part of the line item) based on the Variance (If it is 0 to display message like " No Difference", If it is 1 " Need to take corrective action" )

Kindly Suggest on the same.

Thanks

Usha

Accepted answers

All comments

Niranth

Hi @usha.cherukuri ,

You can't add formula for text in Dashboard.

Alternatively you can add formula for a line item and publish it to the dashboard using "Publish Selected Line item to Dashboard" option.

Hope this helps.

usha.cherukuri

Hi @Niranth ,

Attached the document with detailed screen shots for your reference.

Kindly check on it and suggest on the same.

Thanks

Usha

ChrisAHeathcote

@usha.cherukuri

I would recommend creating a new list called something like, 'variance message,' and populate it with as many members as you have potential messages calling each a number, such as 1, 2, 3 etc.

Using this new list create a new module containing one text formatted line item. For each number in the variance message list write the desired message. We will use this module to map the text across into the target module.

In your target module containing the variance calculations create a line item which queries the variance result and returns the desired number relative such as 1 for 'no difference,' 2 for 'corrective action required.' Call this line item variance message code. These should correspond with the line item contents in your variance message module created earlier.

In the variance message line item in the target use the following formula

=variance message module.variance message[SELECT:variance message list.variance message code]

Quick Links

Can you help?

Unanswered questions

Batch Script
Hello team, I am logging into Anaplan through SSO. I would like to create a batch script to import a file into Anaplan. For the Spoke model, I would like to run an process via a batch script to import data from the Data Hub. Can anyone provide me script for both the condition.
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…