Eliminating the "null" category and values from chart?

Ivanche shared this question 3 months ago
Completed

We would like to have two sets of data in a single YellowFin report: three month data and one month data.

We managed to do this by creating a mother query where we use a "last three months" filter, and appending (via a left join) a subquery where we use a "last month" filter. We could then create a chart that correctly displays data load per month for three months.

However, when we tried to create a chart displaying data load per day for last month, the chart also shows a "null" category. This likely refers to the values that are not represented on the chart, i.e. the two month data that get excluded by applying a last month filter.

Is there a way to join the queries in a way that the null category is eliminated? Or perhaps to adjust the filter/charts so that they do not display these null categories and values at all?

Replies (5)

photo
1

Hello Ivanche,

Thank you for submitting this request to the Yellowfin Technical Support Team. My name is Chegudi Priya and I will be supporting you with this issue. I wanted to reach out to inform you that we are currently in the process of reviewing your account information in our internal system. As soon as we have completed our review and have obtained further information, we will promptly reach out to you again.

Thanks & Regards,

Priya.

photo
1

Hello Ivanche,

Thank you for your patience, I have a couple of things that need to be checked on a live basis, I am happy to jump on a call to see the issue we can schedule this meeting between 03:30 PM IST to 10:30 PM IST. Please let me know your availability for the session and if you require any changes.

Thanks & Regards,

Priya.

photo
1

Hello Ivanche

I wanted to follow up with you regarding the session I requested in my last email. This will allow me to further troubleshoot this issue and work towards a resolution. I know you may be busy but this information is necessary to solve this issue.

Thank you,

Chegudi Priya

Yellowfin Technical Support

photo
1

Hello Ivanche

I wanted to follow up with you regarding the session I requested in my last email. This will allow me to further troubleshoot this issue and work towards a resolution. I know you may be busy but this information is necessary to solve this issue.

If you are unavailable right now, you can always contact us again at a later time by opening a new ticket. I will close this ticket by the end of business tomorrow if I do not receive a reply.

Please reply to this email and I will continue to work to resolve this issue.

Thank you,

Chegudi Priya

Yellowfin Technical Support

photo
1

Hello Ivanche,

This email is to notify you that we believe that you have identified the solution for the reported issue or that this ticket can be resolved for now. Because of age and inactivity, I am going to go ahead and mark this ticket as Completed for now. However, if you are unavailable right now, you can always contact us again at a later time by opening a new ticket.

Thank you,

Chegudi Priya

Yellowfin Technical Support

Leave a Comment
 
Attach a file