Show YTD and selected month?

I have a module view where it has time as a dimension (I'm able to select which period it displays) but would also like to display the annual result next to it. For example, if I was showing Aug 2019 sales, directly to the right, in the same view, I would see the 2019 annual results. Below is a screenshot of what I have currently, the issue is that when they scroll in one, it does not scroll in the other, so they cannot compare selected month results to the entire year's results. 2020-01-09 14_34_04-Greenshot image editor.png

Accepted answers

All comments

rob_marshall

@mwaltz0213 ,

Why have the two dashboard elements and instead, create YTD metrics line items in the same module. That way, you can remove the 2nd dashboard element and everything will be tied together?

Hope this helps,

Rob

Misbah

@mwaltz0213

To answer your question there is no way you can scroll both of these together. You will have to make additional line items in the same module If you really want to compare side by Side.

Also We must understand that Anaplan is not a leading reporting tool (at least as of now). Who knows it will be in the future.

Cheers!

Misbah

Rashmih

Hi @mwaltz0213,

You can set the Height as -1 in Dashboard Designer Properties panel for both grids.

In this way, the dashboard will use the Page scrolling. However, these will work when there are limited items/members in the rows.

More items/list members will delay in loading of the dashboard

dashboard panel - Height Width.jpg

Regards,

Rashmi

Harsha

I agree with @rob_marshall @Misbah two views will not scroll together. You need to put all the information into one view and publish it to dashboard.

Thanks,

Harsha

SandeepB

Hi @mwaltz0213,

As the previous reply says, you can try something like this:

Hope this helps.

Thanks,

Sandeep

ChrisAHeathcote

A possible solution which will allow you to maintain the tow grids is to synchronise the line items.
Allow the user to browse from left to right in the left hand grid and if they required the YTD, FY19 or any time period they can select that column and the right hand grid will sych as appropriately.
Firstly, re-pivot your right hand grid to place line items as a page selector and time period as columns. Use the show functionality to select the required time period aggregation; FY 19 and / or YTD.
Ensure that line times are synchronised in the right hand grid and when the user selects a line item in the left grid the right grid should change accordingly.

mwaltz0213

All - I was able to resolve the issue with adding YTD results into the module and reporting it in the singular dashboard element. Thank you for your time.

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…