3 Replies Latest reply on Feb 4, 2019 12:40 AM by Mahfooj Khan

# compare data for two different months for same diamension

I want to calculate the electricity consumption for multiple buildings for different months and years.

I want to give two filters to user where he can select the two different months of any year and it will show the electricity consumption for each building for two different month and year.

Data should plot only for selected month & year. Suppose user selected the month May 2017 in first filter and March 2018 in second filter

So it will show data only for this two months only.

It should show the graph like this.I have attached the sample data for your reference.

along with building name it should show the visualisation like below graph this graph is showing the electricity usage for two different months selected by user respective with building name.

• ###### 1. Re: compare data for two different months for same diamension

Hi Ramchandra,

Not sure but find my approach as reference below and stored in attached workbook version 10.5 located in the original thread.

1. D1. Date: DATE(DATEPARSE ( "dd-MMM-yyyy", '1-'+[Month]+'-'+str([Year]) ))

2. P1. Date Parameter & P2. Date Parameter based on D1. Date

3. M1. First filter: if [P1. Date Parameter]=[D1. Date] then [Electicity Consumption in Unit] END

4. M2. Second Filter: if [P2. Date Parameter]=[D1. Date] then [Electicity Consumption in Unit] END

5. Drag the required objects to the indicated locations and show parameter controls

Regards,

Norbert

• ###### 2. Re: compare data for two different months for same diamension

Hi Ramchandra,

I am attaching the solution workbook.

Please mask the answer correct and helpful, if it solves the problem so that this thread can be closed.

Cheers,

Rahul

• ###### 3. Re: compare data for two different months for same diamension

Hi,

Find my approach in attached workbook.

I guess bullet chart will be good for such comparison

Note: comparison(Aug 2017) sales=bar; benchmark(July 2017) sales= gantt

Let us know if this help.

Mahfooj

1 of 1 people found this helpful