Forum Discussion
Sum Aggregated Values With Multiple Filters based on Dynamic Range
BI_Noob , need a better sample. I think it same as Continuous streak : https://youtu.be/GdMcwvdwr0o
Hi Amit,
I watched the video and I'm not too sure if it's the same. Attached you'll find a sample dataset. Here's how I got the column to calc what I'm trying to accomplish
=AND(SUM(SUMIFS([Online Orders],[Date],[@Date],[StoreId],[@StoreId],[Hour],[@Hour]),SUMIFS([Online Orders],[Date],[@Date],[StoreId],[@StoreId],[Hour],[@Hour]+1),SUMIFS([Online Orders],[Date],[@Date],[StoreId],[@StoreId],[Hour],[@Hour]-1)) = 0,
SUM(SUMIFS([Phone Orders],[Date],[@Date],[StoreId],[@StoreId],[Hour],[@Hour]),SUMIFS([Phone Orders],[Date],[@Date],[StoreId],[@StoreId],[Hour],[@Hour]+1),SUMIFS([Phone Orders],[Date],[@Date],[StoreId],[@StoreId],[Hour],[@Hour]-1)) > 0)
BI_Noob , Please provide the same in table format. So that I can try. Copy paste from excel.
Hi Amit,
Please see below;
Sorry copy and paste from excel causes an error so I had to create link to file. Let me know if this helps explain. I sincerely appreciate your help.