Forum Discussion

TriveniN's avatar
TriveniN
Icon for Helper II rankHelper II
2 years ago
Solved

How to allow users to enter data for slicer

Hi ,

I have new requirment and in requirment document they mentioned as user has to provide data for slicers("Occupancy Target (%)")

Note : Normally in slicer , we have an option to select data, but here in this case user has to enter data interms of %.

 

Below is the formulae for "Total # of Homes"  and "Target Occupancy at month-end"

SELECT COUNT(*) FROM ACQUIR WITH(NOLOCK) WHERE Unit_Status__c NOT IN ( 'disposed', 'Model' )

 

Target Occupancy at month-end = Total # of Homes * Occupancy Target (%)

when user enter data for Occupancy Target (%) slicer , it will show data for measure "Target Occupancy at month-end" based on user input.

 

Regards,

Triveni N.

 

Need Help
  • qqqqqwwwweeerrr's avatar
    qqqqqwwwweeerrr
    2 years ago

    Hi TriveniN 

     

    Here is the solution that you were looking for i have taken random sample data 
    As per you SQL Query you have to count all the rows expcet disposed and model hence as per my sample data it should be 5.

     

    Now you need to create decimal paramter for which you folow this setp

    and create two measrue first for row conut (total # if homes):

    RowCount =
    COUNTROWS (
        FILTER (
            'Sheet6',
            'Sheet6'[Unit_Status__c] <> "disposed" && 'Sheet6'[Unit_Status__c] <> "Model"
        )
    )
    second to multiple by %: 
    Measure = [RowCount]*Parameter[Parameter Value] here parameter value is user input. this will give you output somethingh like this 

    you can also follow this video for creating paramter: https://youtu.be/O9Be1d_oi6Y

    Did I answer your question? Mark my post as a solution! Appreciate your Kudos!!
    Check for more interesting solution here: www.youtube.com/@Howtosolveprobem

    Regards

     

     

1 Reply

  • qqqqqwwwweeerrr's avatar
    qqqqqwwwweeerrr
    Icon for Solution Sage rankSolution Sage
    2 years ago

    Hi TriveniN 

     

    Here is the solution that you were looking for i have taken random sample data 
    As per you SQL Query you have to count all the rows expcet disposed and model hence as per my sample data it should be 5.

     

    Now you need to create decimal paramter for which you folow this setp

    and create two measrue first for row conut (total # if homes):

    RowCount =
    COUNTROWS (
        FILTER (
            'Sheet6',
            'Sheet6'[Unit_Status__c] <> "disposed" && 'Sheet6'[Unit_Status__c] <> "Model"
        )
    )
    second to multiple by %: 
    Measure = [RowCount]*Parameter[Parameter Value] here parameter value is user input. this will give you output somethingh like this 

    you can also follow this video for creating paramter: https://youtu.be/O9Be1d_oi6Y

    Did I answer your question? Mark my post as a solution! Appreciate your Kudos!!
    Check for more interesting solution here: www.youtube.com/@Howtosolveprobem

    Regards