I have prepared Xcelsius dashboard in Dashboard designer for desktop usage. This dashboard consists of indexing and other logic to filter out data as per combo box value (first tab is where the original data is residing) and there are actually more than 2Lac records, but for testing I have kept 5-6 records with different doc date (last column in the first tab).
In addition to the existing working logic, I need to include Date range and Quarter filter. Date range filter - from date and to date, since user can select more than a years data. QTR filter - It should include Financial Year and Quarter combination, like Q1 2014-15, Q2 2014-15 and so on. I have tried something and was able to flag out records that meet the date range criteria. However, I am not able to include the same in my existing logic. Also, I am not able to implement QTR logic.
I need someone to build the logic for date range and quarter selections. The existing logic for combobox should not be impacted.