Based on calendar selection need to calculate average of count
Hello Everyone,
I have requirement like date, month ,year ,days are in list box and in bar chart count using one dimension field.
as of now i am showing count based multiple selections through list box.but customer asked a requirement like customer will select multiple months and multiple dates dynamically, now from that i have to show latest month of latest date in selection in one bar and in one more bar remaining months of latest date average has to show.
so that customer can compare both values.
ex:
Year
2017
2018
month
jan
feb
mar
apr
may
jun
jul........etc
days
1-30
suppose user select 2017 and months from jan to apr and days from 1-10 now
in first bar apr 10 th data has to show and in one more bar remaining months means jan-mar 10 th average has to show.
to get latest date i can use max(date) for getting latest date results.for calculate remaining selection date average how to built expression.can i achieve this, is it possible?
