Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello,
I have a table with all the dates in 2017, and i wanted to show on the line chart only the dates between 15/06/2020 and 15/07/2020, but am not able to achieve that.
Can anyone help me?
Thanks,
Dan
I'm afraid I make a mistake in the expression. I have now created a test app and I realized I didn't use the double quotes 😬.
With a load script for test like the following:
Data:
load Date(RowNo() - 1 + Date('01/01/2020', 'DD/MM/YYYY')) as Código,
Round(Rand() * 1000) as Quantity
AutoGenerate(365);
I have created two linecharts, with two expressions:
Top linechart:
Sum(Quantity)
Bottom linechart:
Sum({<[Código]={">=15/06/2020<=15/07/2020"}>} Quantity)
And you can see the result:
PD.- I have used Sum() instead of Count() as it is easier than count for this test data.
JG
código is the code of each line, so when i count them it should go line by line.
I tried what you used but still shows error, the data on line is a normal date calendar, and i tried both sum and count ..
@JuanGerardo yeah only got to work with ideas, the filter is nice