Howdy,
Total newbie here.
I am building visualizations by importing data from a CSV file (I know,I know but we already had the files). The files are updated once a month so I am summing data for various categories and displaying that on a time series graph. All of this is working fine, I’m getting graphs.
A little snip of the data looks like this:
“11/01/22”,“AAI”,“System - Tasks”,“DEVE”,11,17,1
“11/01/22”,“ADSBPM”,“ADS”,“East”,44,64,3
“11/01/22”,“ADSBPM”,“ADS”,“North”,35,51,2
“11/01/22”,“ADSBPM”,“ADS”,“West”,25,37,3
“11/01/22”,“ADSBPMB”,“ADS”,“B2B”,24,35,3
“11/01/22”,“AOLISTEN”,“System - Tasks”,“eTNI”,0,0,4
“11/01/22”,“AOLISTEN”,“System - Tasks”,“B2B”,0,0,3
“11/01/22”,“AOLISTEN”,“System - Tasks”,“East”,0,0,3
“11/01/22”,“AOLISTEN”,“System - Tasks”,“North”,0,0,2
“11/01/22”,“AOLISTEN”,“System - Tasks”,“West”,0,0,3
This file is updated once a month, so my data points for a “time” series really don’t have times, only dates, usually the first day of each month. Each file has roughly 2 years worth of data.
I have many files with this format so I’m really just duplicating the visualizations for the moment.
My problem is, sometimes I get a graph with a time display for each hour of each day of the month - this really doesn’t show anything but a flat line since the data only changes once a month.
On other files, I get a more compressed graph covering the entire two years.
I can go up to the time selector and select the entire time, that is from 1/1/22 to 10/2/24, and it will compress into the second view. However even if I make the time selection and save the visualization and dashboard, the next time I view the graph, I’m back to the “uncompressed” time line.
Any help is appreciated.
Thanks,
Greg