Skip to main content

Hello,

 

I have created a calculated item cumulating totals by week for a month. I would like to show the cumulative total of each week on a chart, without showing that week’s individual total. In the example below, I would like to remove the lighter blue “Jan 25” value, and keep the calculated item - the cumulative total by week. Is there a way I can do this? 

 

Thank you!

 

 

 

Hi ​@mmcgrath you could think about using “show value as” for the metric, instead of using a calculated item. If you need to use a calculated item, as a workaround I usually apply a filter to include and exclude the same item, to effectively not showing any item at all except for the calculated item. E.g. Filter “Month is in Dec 25” AND “Month is not in Dec 25”. It can be any month, doesn’t matter in this case, as long as you exclude the same month that you initially filter for with the “is in” filter.

​@oliverlee thank you! I believe the “show value as” has solved my problem. Appreciate the advice!

Reply


Ask your question here!

Terms & ConditionsCookie settings