Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
Am working on Dashbaord for operation where I have filter by Fiscal Year, Month, Week, Day for which am using List boxes and StartDate and EndDate parameters for specific day selections . Right now when I have no data for selected date am displaying all data in the system till date, where as I would like to see blank data upon that data selection like weekends and holidays..
Any help would be appreciated.
Thanks!!
Like I told you, you may need to combine calculation conditions (using getselectedcount() ) and using variables and buttons to enable/disable the calculation condition,
take a look at the example. It's the general idea, but you can adapt it to your case,
regards
looks like your start and end date are variables ... can you provide your expression in the chart.
That condition works for Start Date and End Date variables.
Can I get the same condition like that for Year and expression(which is calculating fiscal month)
In the case of Year and Expression what do you want to limit? is it the number of Years selected or is it something else?
If it's just the number of years selected you can use getSelectedCount(Year) > Number, so you force the user to select n number of Years in order to fulfill the calculation condition
Right now am using condition as this
=sum({$<Date={">=$(=vStartDate)<=$(=vEndDate)"}>} Sales)
How do I write the same for year and month ??
I did try with Buttons and Set Variables as you said but didn't work for me.
hi,
besides the screenshot, could you please upload a sample? It would be better to help you that way,
regards