Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello,
If i have a line graph, with 20 dates. How can i do so it only shows every second date, or every third date?
Ahh - Continuous creates an "expression" you can change under number, so you can make it dates. Then it works.
View solution in original post
If you need to achieve a result like "show only the third country value", you can:
- add a calculated dimension using the following formula : =if(Country=FieldValue('Country',3),Country,Null)
- enable the "Suppress When Value Is Null" for this expression
I want all values, i just dont want to show all the dates....
Like the function Continuous in the Axes tab. But Continuous shows numeric values. Not dates
Hi,
Go to the properties->Dimension Limits You can specify the limitation for your date shown in dimension
Based on what? Cause i dont want to see the smallest only, neither the largest only. and neither only the first 10.
Ok...so try this
- add a calculated dimension using the following formula : =if(Country=FieldValue('Country',3),Country,'')
- DO NOT enable the "Suppress When Value Is Null" for this expression
=if(Date_Clean=FieldValue('Date_Clean',3),Date_Clean,'')
not working . Only gives me one value
Sorry if I didn't understand your post ("I want all values, i just dont want to show all the dates....")... I understood that you would see all chart rows but only a date for date dimension...
Let me specify.
I have a line graph with revenue the past 20 days.
i want a line graph with revenue the past 20 days, but where only every second date is shown. But the value for the hidden date is ofc shown.
Hi Thomas,
Within the Axes tab you can check continuous.
Add static step 2 if you'd like to show every other date
