Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Filter data per day in the report

Hello,   I have generated data for 150 employees for the last 5 years. In my SQL table. Currently, I have data like this in my table   Employee Id Employment start date Employment end date ...
  • Icey's avatar
    Icey
    6 years ago

    Hi Anonymous ,

     

    I don’t think you need to create another measure. Just remove "Trend data" column from your table visual.

     

     

    Best Regards,

    Icey

     

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Hi Rocco,

 

Thank you for your reply. I can do that but I have a date range. When a user selects a specific date then It should sum the data based on the selected date. I have around or less than 1 Million data for a direct queries. 

Anonymous's avatar
Anonymous
Not applicable
6 years ago

hi Anonymous ,

then you want a function that has in input an ID and a data range i.e. {data1,data2}   and should output the salary sum (FTE sum) for that ID for days from data1 to data2?