I have a bar chart which looks at data for the last 7 days and have a KPI Chart which reacts to the bar chart and shows the total volumes selected. Well this is what I want to happen but currently the bar chart shows the right numbers but the KPI Chart volumes count all volumes.
Currently my bar chart attributes are:
DIMENSION: if(New_Date>='$(=Date(max(New_Date)-6))' and New_Date<='$(=Date(max(New_Date)))',New_Date)
MEASURE: =Count({<Flag={'AO'}>}Alert_C)
My KPI Dimension is =Count({<Flag={'AO'}>}Alert_C)
With te KPI Dimension I currently have, it counts total volumes ever received and not the date range i have in my bar chart.
Is there anyway I can get them to speak?
I've attached a photo to hopefully help with what i'm saying as i'm not sure if i explained it very clear.
