-
Waterfall Charts color for case Opening increase decrease Closing
Hi all, I am creating a waterfall chart for a movement use case. The movement use case starts with Line Items Opening, Increase, Decrease and the Closing (being the Parent). The Increase and Decrease should red/green depending the contribution to the Closing. The Opening and Closing should be blue. The challenge is to get…
-
Conditional Format Based on Max and Min of Displayed Data
Is it possible to set the scale of a conditional format to the Max and Min of the values being displayed. It is often the case that depending on which end user is reviewing the data the values there in are vastly different and setting a max and min that is unervisal is impossible. Thank you, Mark
-
Synchronised paging across multiple dashboards
This may be a very simple question so apologies if it is! I have two tables on a dashboard that I want to be synchronised therefore I have synchronised paging checked, however, this also seems to synchronise it to another dashboard if I have both open and change that. Is there a way to enable synchronised paging within one…
-
Dynamic Chart is not working after changing Time Settings
Hi, I have published some dynamic charts by having "Time Filter" line item to control the periods display. Those charts have been published with the Time Settings with 1 future year and current period of 'Mar17'. However, when I change the current period to one year later then the chart won't dynamically update and still…
-
Waterfall chart
Hi, Waterfall chart is showing for all values as "Upwards direction" as shown below: I WAS EXPECTING to be like this below. Does we need to write any expressions/formula to set Net1, Net2, Net3 and NetRevenue to start from 0 instead of prev line item ? Thanks, Satish.
-
Graph without 0
Dear all, I'm new anaplaner, and i would like to publish a graph in a dashbord without revealing values egal at 0. Is it possible ? if yes, how ? Thank's a lot for your help!
-
Support ticket system (list/dashboard)
Hi, I am not sure if its doable, but will give max kudos who could help. I am planning to build ticket system where sales rep could input details on his own dashboard and anaplan admin could see on his own panel those questions and respond to them with brief solution/explanation and changing case status (not reviewed, in…
-
How can I create a stacked chart in the order I want?
I have a dashboard with 2 charts, as above. How can I create the stacked chart in the order I want? Right now "Gap to Plan" and "Gap to Budget" are all at the top, but I want them to be at the bottom. There doesn't seem to be an option to specify this. Thanks for help!
-
How to generate a clustered and stacked chart
Hi, I would like to generate a chart combining clustered one and stacked. If the product list and line items such as Budget, Forecast and Actual are specified as dimension, is it possible to generate a chart like the attached? Best regards, Maki Yasuda
-
Map charts
Hi, A certain limitation with the map chart that I'm not able to overcome. I need the map to change dynamically based on a page selector. Map charts don't load up without line items as the data field but at the same time line items can't be published as page selectors. So I can't change the line items to a list because…
-
Scale on Dashboard Graph
I am unable to set or manually change the scale on a graph published to a dashboard. And the automatic choice is poor - in screenshot there is no data point above 10K but the scale goes to 20K. I would prefer being able to set the scale myself but automatic would be OK if it did a better job....
-
How to reference a page selector
How can I use an existing page selector in a dashboard, to filter a line item that is using the same list? I have created a module that uses a country list as a dimention. Then, I created a dashboad to pull this module and used the same list as page selector. Now I have created an other module, but on this module I am…
-
Showing source records
Hi, When elements of chart on a dashboard are clicked by users, we want the corresponding source records to be displayed. If you have any recommendation, could you tell me how to implement that? Thanks and regards, Maki Yasuda
-
Select multiple items from drop down
Would be great if users can select multiple items from drop down. Now you can either select the parent or the child of a list, but not a selection of children. Our users are organized in clusters of items. So when they need to update or export data they need to do child by child.
-
Selective access on payroll data
Hi all, I want to provide employee names and teams for some users but not give them access to salary and confidential information and have created a dashboard that hides all the sensitive information. However the user is still able to see the information by right clicking the column and unhiding all. I have tried…
-
Lines cut off from table on dashboard
Hi, I'm trying to place a table with data on one of my dashboards, however it seems to always be cutting off the last few lines. Setting height and width to 100% doesn't help, neither does resizing by dragging the right bottom corner; the last 2-3 lines will always be cut off on the dashboard. When exporting they are…
-
Different Versions with different formats
Hello everyone, I have a question regarding formatting of my version columns. For example, I have two versions Actual and Forecast , and a third one being Actual divided by Forecast. However, when making a table, showing all data, the third version is shown as a number and not as a percentage. Is it possible to change just…
-
Changing fiscal year start month without losing data
I've got a model in to which I've input monthly data running from February 2016 to present (January is empty). As February is the first month of our fiscal year, I want to change this from the default January. After doing so, I get the following pop-up: [quote]Changing Time Settings is a potentially destructive action and…
-
How to publish Combination Chart
Hi Anaplan Users I'd like to publish Combination Chart into certain DashBoard. but I coudn't publish it. I can make one but when I click "Publish To Dashboard", It cannot be published into Dashboard. Does anyone have same phenomenon ? If necessary, I'd be glad to provide a further information. Thank kyou for your replying…
-
Dashboard Best Practices & Example
Dear All, My objectiv is to gather the Best Practices and Examples of Dashboards to improve the customer experiences and play with all capabilities of Anaplan. Apart from the main Best Practices available on the Learning platform, there is a very few Tutorial or Sample of interactiv and original dashboards. If you have any…
-
Sync Between different lists on Dashboards
I have two Dashboards with modules on them using different lists. Dashboard 1 module has list l1 which has many levels of Hierarchy and the other module in Dashboard 2 has list l2 which is made out of the lowest level of hierarchy of list l1. Now what I want is that if I choose a certain list member in the module element…
-
Chart Scale Resizing Behavior
Hello, Has anyone seen this behavior on a chart? It doesn't always happen so I suspect that it depends on some edge cases in the values being displayed. In cases where it does happen it is repeatable however. (Reload the dashboard and its back to normal and then repliciate the process shown here.) Selecting a different…
-
Formatting on non-lineitem dimension
Hi, I have a requirement where users want to have ability to manual key-in or formula by colums while they still want to do formating by rows (make header/summary/conditonal color formatting....) I know that Anaplan only support lineitem dimension to have formula or formatting. But is there any workaround for this…
-
Formula for Selected Months
Hi everyone, Warm greetings to all! May I ask how can I make a formula applicable on selected months only? Thank you!
-
Customizing line items based on Page selector
Hi, I want to hide/show certain line items based on item selected in Page selector. How can I do that? For instance : I have items in a page selector : x,y,z and line items : a,b,c,d,e If x is selected then only a and c needs to be shown. Is there a way to do this?
-
User Specific View
Hi, We created a download page (basically a dashbord) and we guide our users to it but they need to filter on themselves in order not to get everyone's data. Is it possible, for any given dashboard, that Anaplan recognizes who the user is, what "region" and "products" and "team" they are aligned to rather than show all…
-
Referenced on Dashboard
I have noticed that referenced by only shows where a module is referenced by other modules. Is there a way to see if a module is used on any dashboards? Thank you, Mark Peck
-
Time - Synchronize Selection bug? (column)
Hi, I have published page selectors to a dashboard which include Time but when I select any of the months, the module does not sync to show that month only. Also, If I select any period beyond what shows as the default (selecting May 16 when Q1 FY16 shows by default when opening dashboard), then the module will not even…
-
Page Breaks in PDF Exported Dashboards
Hi Everyone, Is it possible to control where the page breaks when exporting a dashboard to pdf, for example to ensure that an entire module view is fit to one page instead of cut in half? Thank you.
-
datetime
hi guys, I am just starting . . . . perhaps stupid question: is it possible to display the datetime on a dashboard when an action button has been pushed ?? Herman