11 Replies Latest reply on Aug 16, 2016 1:22 PM by David Mostoller

# Daily running total - how to show only the monthly sum of the daily running total

Hello all,

I have a workbook where I am trying to show the number of days in a month that were under a certain threshold.  I have my formula to calculate whether the day was under the threshold level, and then output a 1 if it was under, and 0 if it was over. Than I set up a running total to show the culmulative # of days that were under the threshold, which re-sets at the end of each month.

But I don't want to display the daily totals, just the final count at the end of each month. How can I take my daily running total and display only the sum on the last day of each month? I have a filter to show the last 12 months of data, I just can't figure out how to display only the monthly total, rather than every single day. If I do it by month than it takes my calculation for the whole month, so even if 12 days were under the threshold, it displays "1".

Dave

• ###### 2. Re: Daily running total - how to show only the monthly sum of the daily running total

just posted it

• ###### 3. Re: Daily running total - how to show only the monthly sum of the daily running total

Sorry, i didn't see before.

• ###### 4. Re: Daily running total - how to show only the monthly sum of the daily running total

I posted it after you asked, sorry about that! forgot to attach it the first time, thanks for noticing

• ###### 5. Re: Daily running total - how to show only the monthly sum of the daily running total

This dash is in Tablaeu online.

We don't have access.

• ###### 6. Re: Daily running total - how to show only the monthly sum of the daily running total

well its using data from my company... im not really sure how to share it. But maybe you have some ideas that can help just from my description... basically just a daily running total but I want to see only the monthly total

• ###### 7. Re: Daily running total - how to show only the monthly sum of the daily running total

To share you need to create a local data file, a tde or a xls to replace into the app.

• ###### 8. Re: Daily running total - how to show only the monthly sum of the daily running total

unfortunately I do not have permission to make a local copy of the data source...

• ###### 9. Re: Daily running total - how to show only the monthly sum of the daily running total

If you create a xls file with some fields and some fake value is possible to replace without real data.

• ###### 10. Re: Daily running total - how to show only the monthly sum of the daily running total

okay I will do that, thanks for your help

• ###### 11. Re: Daily running total - how to show only the monthly sum of the daily running total

So here is a screenshot... the measure value returns a 1 or a 0 for any given day, which then has a running totoal that re-sets at the end of the month. I want to display only the value on the last day of the month, for the last 12 months... and not show the daily breakdown. Maybe this helps Luciano Vasconcelos