Straight table

[Pujitha]

Hello all,

In straight table I restricted to first 10 values because if I give date range lots of records going to display so i don't want to display all the records which is not safe. So I restricted to first 10. But when I change date ranges as suppose 11/12/2018 to 12/25/2018 so many records will be there - I want to display top 10 in this date range (I mean whatever date range the user selected) and when we are export this to notepad all the thousands records should be export to notepad instead of only 10 Is that possible. Please let me know as soon as possible. Thanks!

[tincholiver]

Hi Pujitha,

Put dimenssions  limits at 10, in the expression  sum({1} quantity).

No selections will modify this top ten.

I hope it help you.

Regards

[Pujitha]

I need to get the 10 columns according to the selection of date ranges. I need to show first 10 from those particular date range If I change the date range again it will show the first 10 in this date range like that I need to show. And while export to notepad I need to get not only this 10 all the records in the selected date range should come. Can we achieve this?

[tincholiver]

Can you share some rows of the table?

[Pujitha]

First name Last name  Records  classifications and so on. I want to hide all the columns in the striaght table it should display/show  only when I select the date ranges. Could you please help me how can we do this.

[tincholiver]

So, you can try with variables in a date range, the result is something like this:

If no data recorder in this range display nothing, but if you have data will show the top ten in this range.

For this you have to create two variables, Fecha_Desde and Fecha_Hasta (Configuration/Panel Variables),

after this create a calendar for each variable,

put in the dimenssion limits at 10

and finally in the expression : sum(if(Date>=vFecha_Desde and Date<=vFecha_Hasta, Cant,0))

let me know if was useful.