Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I am having issues expressions and creating a line chart from my data.
I have
[Date] [CurrencyType] [Country] [Units Per USD] [USD Per Unit Month] [Year] [Month]
I have QVDs for entire years of data from each country saved in each. I cant seem to display it in a chart at the moment. I think i'm close but missing something.
For example I want to display the last 30 days worth of data from a particular country. Lets say CurrencyType = 'AUD'
My dimension is the date of course but it just isn't working
Ideally i would like an updating chart that displays the previous 30 days of data that will update each day as ever day i would have new data coming in to my QVD. For example one expression for AUD, one expression for HKD, one for JNY for [Units per USD]
Ive managed to do this before but my data was in a different format than this one.
Any help would be appreciated
Please read these two documents: