MTD SUM BY EACH WEEK IN MONTH
Hello Sisense Community! I have the following draft of a column chart:
There is a dashboard filter = last month (Jan. 2022). This is currently showing a sum value for each week based on this ...
Forum Discussion
Hi cartercjb !
You could use RSUM() function for accumulating your measure by the sorting order of the dimension.
RSUM((SUM([METRIC]),[Weeks in Date]))
Thank you, Angelina_QBeeQ !! What if I were to flip this around just slightly..
So I have a KPI that is showing a MTD sum. Below that I would like to display a trending microchart that shows the same MTD sum calculation, but from 7 days ago. So it would essentially be a MTD sum from last week. Any suggestions on that? THANK YOU!
Try to use PastWeek function inside RSUM like this:
RSUM(PastWeek([Total Sales Value]))Angelina_QBeeQ harikm007 so I was able to get the microchart to correctly sum each week by changing the date dimension from month to week:
However, now I can't get the overall/main red KPI to show the total MTD value. It is showing the first week's value:
when I am seeking the last week's value (1734):
Is this able to be accomplished?
