[Filter: smut] RobBird82's post body matched "*harshitha*", board "forumsmisc".

RobBird82

[Filter: smut] RobBird82's post body matched "*harshitha*", board "forumsmisc".

Post Subject: Re: Time summary setting for a line item with "Formula" summary setting.

Post Body:

Hi harshitha.narayan@sony.com 

 

Not sure if any of these suggestions will work for you... but thought I would throw a few of them out. I would be inclined to leave the summary data turned on. If you really do want to remove it, then setting the summary to none and leaving the time summary will result in a blank box in the summary column. If you then create a graph having selected your cumulated line item for a classic dashboard, Anaplan should ignore the empty field and the graph should be complete.

 

Alternatively, I would filter those columns having not changed the summary settings from the default (you never know when you will be asked for high level versions of the data by an inquisitive Director). Applying the filter then creating a new saved view. For the filter, I would recommend making a SYS Time module if you haven't already and adding a Boolean line item for the period you want = "Days Only", "Weekdays Only", "Weeks Only", "Months Only" etc. set to true. You can then use this in the filter on the module to remove any summary columns from view without losing that data. The saved view only having the lower level data, and you can create your graph from the line item then.

 

If you set up the SYS Time filter module, when using UX to create your graph, on the formatting page you will be able to apply a filter before the graph is shown on the board. Exactly like the above process, the filter for the lower level of data (days, weeks, months) will result in summary data being excluded. Applying the filter at this level and within UX means you will not need to amend anything within the module or make additional saved views. While achieving the same result.

 

Just a few of the first ideas that occurred to me, but others might have better or more options.

 

Hope these are of help.

 

Kind Regards
Rob 

Body text "harshitha" matched filter pattern "*harshitha*".

Post by User[id=49563,login=RobBird82] has message uid 118668.

Link to post: Re: Time summary setting for a line item with "Formula" summary setting.