Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi stalwar1
addition to this Not reflecting
now the data is showing for last 12 months .
but when I select month as a filter the chart is not reflecting it is showing always fixed data only how to avoid this?
What is your current expression?
here it is
used dimension: =aggr(if(JNum>=$(vMTrend),MonthName([JDate])),[JDate])
measure1: count({<[FStatus]*={'Joined'},[In/Ex]={"In"}>}[ID])
meausre2: count({<[FStatus]*={'Joined'},[In/Ex]={"ex"}>}[ID])
added * as per your suggestion previous thread its working for filter [in/ex]
for month filter it is not working
if I select any date range its not reflecting
It just don't do anything when you make selection in Month field?
the selected month line should show in chart sunny
right now its not happening when I select month
What is it showing then? I mean either share a sample or images or something to show what is going on. I don't understand what it does when you select a month