please find the attached workbook and let me know if you need any changes.
i have created following fields with the data given in the attached workbook.
Created four Parameters Curr Start date, Curr End date, Pre Start date, Pre End date with 3 months difference
IF [Custom_Date] >= [Curr start date] AND [Custom_Date] <= [Curr End date] THEN [Count] END
IF [Custom_Date] >= [ Pre start date] AND [Custom_Date] <= [Pre End date] THEN [Count] END
IF SUM([T1]) > SUM([T2]) THEN "High Indicator"
ELSEIF SUM([T1]) < SUM([T2]) THEN "Low Indicator"
ELSEIF SUM([T1]) = SUM([T2]) THEN "Equal Indicator"
Information_Book1.twbx 71.5 KB
In the Dashboard i can't show 2 parameter sliders - Start date and end date slider filters
I should show only single slider in the dashboard
Is there a way to Concatenate two date parameters into Single Date or away to Create this Logic with date function without using parameters
I tried start date - Min(date) , End date - Max(date )
calculated the date difference
Prev start date - Min(date)-date Diff
Prev end date - MIn(date)-1
Currently I have used only one parameter and created your requirement
We need to use parameter for getting 3 months data or comparison we cannot use filter for comparison as separate columns
please find the attached workbook.I made sheet 3 for your reference and validation
Information_Book1.twbx 91.2 KB
But I have a requirement to show single date slider with start date and end date where user can select "n" Number of months
if user selects 5months he should see indicators calculation based on last 5 months and current 5months
Try to validate the changes in the attached workbook sheet3.
i think you requirement is as shown in the below figure. if you put the date in the filter shelf and select range of dates option, you will be getting the #Count# values only between the dates selected in the filter, can't get the previous months data. ( Try to explain to your end user)
so to my knowledge you should definitely use a parameter date and another parameter for No. of months to change dynamically.
below are the changes made in the attached workbook.
Added new parameter (No Of Months) range from 1 to 100.
T1 (Current Duration count)
IF [Custom_Date] >= [Choose date] AND [Custom_Date] <= DATEADD('month',(INT([No Of Months])-1),[Choose date]) THEN [Count] END
T2 (Previous Duration Count)
IF [Custom_Date] >= DATEADD('month',-INT([No Of Months]),[Choose date])
AND [Custom_Date] <= DATEADD('month',-1,[Choose date]) THEN [Count] END
Information_Book1.twbx 84.9 KB