Hi!
I currently have a sheet which shows incoming volumes.
The dimension expression: is =if(Len(New_Date)>0,Date(New_Date,'DD-MM-YYYY')) & the measure expression is:
=Count({<Flag={'AO'}>}Alert_C)
//=if(GetSelectedCount(New_Date)=0,Count({<New_Date={'$(=$(vMaxDateminus1))'},Flag={'AO'}>}Alert_C),Count({<Flag={'AO'}>}Alert_C))
//=Count({<New_Date={'$(=$(vMaxDateminus1))'},Flag={'AO'}>}Alert_C)
//=if(GetSelectedCount(New_Date)=0,Count({<New_Date={'$(=$(vMaxDateminus1))'},Flag={'AO'}>}Alert_C),Count({<Flag={'AO'}>}Alert_C))
//=Count({<New_Date={'$(=$(vMaxDateminus1))'},Flag={'AO'}>}Alert_C)
//=GetSelectedCount(New_Date)=0,Count({<New_Date={'$(=$(vMaxDateminus1))'},Flag={'AO'}>}Alert_C),
//=Count({<New_Date={'$(>=$(vMinDateminus1)<=$(vMaxDateminus1)'},Flag={'AO'}>}Alert_C))
//=Count({<Flag={'AO'}>}Alert_C)
//=Count({<New_Date={$(=$(vMaxDateminus1))},Flag={'AO'}>}Alert_C)
//=Count({<{<New_Date={"23/12/2019"},Flag={'AO'}>}Alert_C)
//'$(vMaxDateminus1)'
I was wondering how I would have the bar chart default to show the last 7 days of data rather than every entry.
