Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi guys,
I have a table loaded like this:
Year/Month/Value
2019/1/4324
2019/2/4335
...
2020/1/43543
2020/2/45454
...
I need to compare in a bar chart sum(value) on year 2019 with sum(value) in 2020
how can I do this ?
pls advice.
thanks.
so load
Data:
load
subfield(Datafield,'/',1) as Year,
subfield(Datafield,'/',2) as Month,
subfield(Datafield,'/',3) as Value
from your datasource;
and then create a bar chart,
Year as dimension, sum(Value) as extression.
Regards
not compltely clear on the issue.
why not add year as a dimension?
so load
Data:
load
subfield(Datafield,'/',1) as Year,
subfield(Datafield,'/',2) as Month,
subfield(Datafield,'/',3) as Value
from your datasource;
and then create a bar chart,
Year as dimension, sum(Value) as extression.
Regards