Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hey guys,
Its possible to create a combined bar/line chart like this?
Dec/17 = 2017 accumulated
Dec/18 = 2018 accumulated
1T19 = First 2019 trimester accumulated
and next months.
Tks guys!!!
opa Antonio
tudo bem?
só corrigindo a postagem da formula da mascara
Ceil(month(QuarterEnd(field_date))/3) & 'T' & YEAR(field_date)
o restante parece estar ok
Hello Antonio,
try to create another a table with this values and use this new fields in your chart, or maybe add a calculated dimension.
J.
I don't think if it will work for me, because I will update every week. I'm looking for something automated.
Hi
you can do something automated using the script load with Resident
something like:
table_date_Mask:
Load distinct
field_date as field_date_new,
field_date as field_date_mask
resident your_table;
table_date_Mask:
Load distinct
QuarterEnd(field_date) as field_date_new,
QuarterName(field_date) as field_date_mask
resident your_table;
table_date_Mask:
Load distinct
YearEnd(field_date) as field_date_new,
Year(field_date) as field_date_mask
resident your_table;
the problem i see this way is that it will take a lot of processing
but the result is as expected
Hi,
I think it can works for me. Could you help do create my dash?
I applied your script but how I use on chart?
Tks!!
if it is an accumulated sum:
sum(if(field_date <=field_date_new, value))
it is important that this new table is not linked to any other table
on the x axis place the field
field_date_mask
in the classification put the field
field_date_new
Sorry where is classfication to use the field?
HI,
I think is something missing here. Look it.