topic Re: Chart for comparison of time periods with multiple measures in App Development

Chart for comparison of time periods with multiple measures

jonathanrichey — Sat, 16 Nov 2024 03:44:36 GMT

Which chart is best to display a comparison of time periods for multiple measures? I can get one period to show using a pivot table, but I am not able to get it to work with different periods.

Attached is what I am trying to achieve, but each measure’s set expression is different. Values are just samples.

Re: Chart for comparison of time periods with multiple measures

sunny_talwar — Mon, 23 Dec 2019 13:40:46 GMT

This can be done using a pivot table as well... you just have to be a little creative here...

Re: Chart for comparison of time periods with multiple measures

jonathanrichey — Mon, 23 Dec 2019 13:52:18 GMT

The current year and previous year stack when I try to add periods.

Re: Chart for comparison of time periods with multiple measures

sunny_talwar — Mon, 23 Dec 2019 14:19:10 GMT

May be share 10-15 rows of data and provide the exact output you are looking to see based on the data provided

Re: Chart for comparison of time periods with multiple measures

jonathanrichey — Thu, 26 Dec 2019 14:42:12 GMT

Attached is a qvf and sample data.

Re: Chart for comparison of time periods with multiple measures

sunny_talwar — Thu, 26 Dec 2019 15:05:57 GMT

I know you shared how you want the output to look like... but based on the data provided? What columns are you expecting to see?

Trend
- Oct-19
- Nov-19
- Dec-19
Month-to-Date
- Actual -> Is this between 12/01/2019 till 12/26/2019?
- Prior Year Actual - > Is this between 12/01/2018 till 12/26/2018?
- Over /(Under) PY -> What exactly is this?
Year-to-Date
- Current Year Actual -> Is this between 01/01/2019 till 12/26/2019?
- Prior Year Actual - > Is this between 01/01/2018 till 12/26/2018?
- Over/(Under) PY -> What exactly is this?

Re: Chart for comparison of time periods with multiple measures

jonathanrichey — Thu, 26 Dec 2019 14:58:50 GMT

See comments below in red.

Month-to-Date
- Actual -> Is this between 12/01/2019 till 12/26/2019? - Correct. Actual period of the Month.
- Prior Year Actual - > Is this between 12/01/2018 till 12/26/2018? Correct.
- Over /(Under) PY -> What exactly is this? I should not have included this. This will be the difference in the two columns.
Year-to-Date
- Current Year Actual -> Is this between 01/01/2019 till 12/26/2019? Correct.
- Prior Year Actual - > Is this between 01/01/2018 till 12/26/2018? Correct.
- Over/(Under) PY -> What exactly is this? I should not have included this. This will be the difference in the two columns.

Re: Chart for comparison of time periods with multiple measures

sunny_talwar — Thu, 26 Dec 2019 15:24:35 GMT

You want something like this?

Check out the attached qvf file.