Dear visitor, despite the COVID-19 outbreak, our team continues operating at full speed.

Also, here is the form where you can apply for a special discount and we will contact you with possible options. Stay safe and continue achieving your business goals.

Fill the form
Get Free Trial
Get Free Trial

Chart with Date (Year expanded)

Answered
Randolph Kepplinger asked on March 27, 2020

Hello,
 
I am trying to get a linechart where Year and Month of due date are expanded, tried to wor with expand call as well as drill but couldnt get it to work.
 
Please find attached report config and example data as well es a scrennshot on what I would like to do.
 
can you help me on ow to open the Year dimension?
 
kind regards
 
Randolph
 
 
 

Attachments:
p1.png

4 answers

Public
Randolph Kepplinger March 27, 2020

report config attached

Attachments:
report-2.json

Public
Randolph Kepplinger March 27, 2020

example data attached.

Attachments:
data.csv

Public
Illia Yatsyshyn Illia Yatsyshyn Flexmonster March 27, 2020

Hello, Randolph,
 
Thank you for your question.
 
We would like to kindly inform you that the data set and the report you have provided seem to be incompatible.
 
However, we did manage to prepare a quick sample that uses a data set generated using your structure as a template.
You are welcome to check out it by the link.
 
It demonstrates how to drill-down months using the drills object.
 
Our team would like to kindly draw your attention to the fact that it is always possible to configure the desired view manually and save the report in order to be able to apply it later or use it as a template.
 
Please let us know if it works for you.
In case the functionality demonstrated in example does not cover your needs, our team would like to kindly ask you to provide some additional explanation about the result you desire to achieve.
 
We are looking forward to hearing from you.
 
Best regards,
Illia

Public
Randolph Kepplinger March 27, 2020

Hello Illia,
 
works like a charm, thanks for your support.
kind regards
 
Randy

Please login or Register to Submit Answer