Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi all,
i want to show the ranges as amazon list way? how can i do this?
req1 : how many values present in that perticular ranges?
like 0-100 (50)
101-200(70) like that
req2: how can i give the two input boxes then user can enter their ranges and see their data? how can use single column for two input boxes?
Note: i have a column with Ranges like below
if(TotalAmount >10000000,' 10M+',
if(TotalAmount >1000000 and TotalAmount <=10000000 ,' 1M to 10 M',
if(TotalAmount >100000 and TotalAmount <=1000000 ,' 100K - 1M',
'$0 to 100K'
))) As Range_Filer
Hi,
1: take Range_Filer as list box and then go to list box > property > General > tick Show Frequency
Regards,
thanks but for input box how can i do?
Hi Bala Bhaskar any idea?
Hi Sony,
First use INPUTFIELD function in backend like
INPUTFIELD TotalAmount
Create alternate states for same column
Create Pivot table and add Dimension as No(Your Dimension) and measure is ,
Measure 1: InputSum({a}TotalAmount)
Measure 2: InputSum({b}TotalAmount)
Measure 3: if(TotalAmount >10000000,' 10M+',
if(TotalAmount >1000000 and TotalAmount <=10000000 ,' 1M to 10 M',
if(TotalAmount >100000 and TotalAmount <=1000000 ,' 100K - 1M',
'$0 to 100K'
)))
above function you manually enter the value for TotalAmount.
Note: Here a and b is my alternate states name
Please Find Below app.
thanks vishal.. but user want input box only.
how can i ahcieve this? input box and slider object ?
May be like this:
Create variables in UI like:
Let vMinAmount = Min(TotalAmount);
Let vMaxAmount = Max(TotalAmount);
Let vTotalAmount = Concat(ValueLoop($(vMinAmount),$(vMaxAmount)),',')
List values by,
In Input box select vTotalAmount.
Same expression in two inputboxes.
if use same when user enter range same values dispalying in input box.
here user should enter two range values in two inputbox the result should display in stright table
Create 2 variables for vMinPrice and vMaxPrice and use the inputbox so that the users can enter their custom range.
In the expression either you can use a single expression with the if condition or you can use two separate expressions with the condition show -
Expression 1 - whatever you are using currently like may be count(Items)
Conditional show will be when value of vMinPrice and vMaxPrice is null.
Expression 2 - Count({<Price={">=$(vMinPrice )<=$(vMaxPrice )"}>}Items)
Conditional show will be when value of vMinPrice and vMaxPrice is not null.
Fele free to share a sample for more exploration.