If i have a line graph, with 20 dates. How can i do so it only shows every second date, or every third date?
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
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
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.
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.
Within the Axes tab you can check continuous.
Add static step 2 if you'd like to show every other date
yes, but it would show me dates in numeric way. So it makes it to numbers like 40152
I tried and it shows me data in date format.
Create a custom field in script populated only with data you need (e.g. Step_2_Date) and use it in your chart.
I have no other ideas.
it did? At my place it change them from dates to numeric numbers.
Ahh - Continuous creates an "expression" you can change under number, so you can make it dates. Then it works.
In axes tab use continuous in x axis and static step=2 and in number tab make the format as date
Retrieving data ...