Hi, :) :)
Could you please confirm my understanding if you could or let me know of a better way,
I have to develop a chart as it is shown in the mockup (Bar). On each bar, it needs to show
the average time that is takes based on a total cars sold. So, if 2 Benz sold based on the attached
data, it would be 12/2=6 Average days for selling Benz at my dealership. It'll need to be done for last
30 days.
Please see attached.
1) Create a main Query to have all the data items.
2) Create Main Query Filter to use _Days_Between to go back 30 days.
3) Create a Data Item (Time_Took) in the Main Query to get the Duration for Benz. It'll be based
on the last 30 days since the initial part of the Query will filter the data for the last
30 days.
4) Create a Data Item (Cars_Sold) using the count statement for Benz as the Car Type.
5) Create the final Data Item (Benz_Avg_Sold) that will include something like below,
Time_Took/Cars_Sold for Report and set the aggregate to Average.
6) Drop the Measure Benz_Avg_Sold as one of the Series Primary Axis for the chart.
What do you guys think? Thanks for your time.
Quote from: HelloCognos on 10 Mar 2018 09:21:49 AM
Hi, :) :)
Could you please confirm my understanding if you could or let me know of a better way,
I have to develop a chart as it is shown in the mockup (Bar). On each bar, it needs to show
the average time that is takes based on a total cars sold. So, if 2 Benz sold based on the attached
data, it would be 12/2=6 Average days for selling Benz at my dealership. It'll need to be done for last
30 days.
Please see attached.
1) Create a main Query to have all the data items.
2) Create Main Query Filter to use _Days_Between to go back 30 days.
3) Create a Data Item (Time_Took) in the Main Query to get the Duration for Benz. It'll be based
on the last 30 days since the initial part of the Query will filter the data for the last
30 days.
4) Create a Data Item (Cars_Sold) using the count statement for Benz as the Car Type.
5) Create the final Data Item (Benz_Avg_Sold) that will include something like below,
Time_Took/Cars_Sold for Report and set the aggregate to Average.
6) Drop the Measure Benz_Avg_Sold as one of the Series Primary Axis for the chart.
What do you guys think? Thanks for your time.
By Using two List data we have get the chart?
could you explain what you want to get the result?
Regards,
Pratap
Thanks. Changed Project. After something else. Will get back later!