topic Re: Ugrent : Please advise Zero Values for Bar chart in App Development

Ugrent : Please advise Zero Values for Bar chart

itsme123 — Thu, 08 Oct 2020 20:13:58 GMT

i have col1 date ;col2 id

I have temp calendar created which has all dates for missing dates by using col1 (temp calendar date col is called col3)

Im trying to get bar chart show zero values with col3 and count(col2).. when i just put col3 in table it does show all dates the moment i add count(col2) it populates data only for the dates which has values like shown below

I want to show like below example when there is no data show blank space ....please let me know how to do it and also the x axis should show dates in reverse order starting from today oct8th oct 7th oct 6th

Re: Ugrent : Please advise Zero Values for Bar chart

Lisa_P — Thu, 08 Oct 2020 22:54:00 GMT

What is your data model ?

Re: Ugrent : Please advise Zero Values for Bar chart

avinashelite — Thu, 08 Oct 2020 23:17:23 GMT

Actually its missing data scenarios, try like this after creating col3 join the original table with co1 and col2 by renaming col1 as col3then use col3 in dimension and count(col2), you will get the results

Re: Ugrent : Please advise Zero Values for Bar chart

itsme123 — Fri, 09 Oct 2020 04:27:30 GMT

thanks I did use the logic but it did not work for me because seems its related to access issues for users to see missing data.

Your response does work in real time. its just i had weird section access for the app

Re: Ugrent : Please advise Zero Values for Bar chart

ioannaiogr — Fri, 10 Sep 2021 12:02:39 GMT

Hi @avinashelite , sorry i didn't get the scenario and I'm thinking it might be the solution to my case as well.

For me it's

original_table:

date_col_timestamp,

date(floor(date_col_timestamp),'DD/MM/YYYY') as date_col

I have a master calendar table in which field TempDate is as date_col from original table and that's how i connect them.

This doesn't allow me to show bars with 0s for missing dates as in @itsme123 's case.

Please help me out!

Thanks in advance