Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi
Can someone tell me how to do a bar chart like below. I cant get it right.
Do you have a calendar? If yes, put your yearmonth as dimension, if not put Monthname([Created date])) as Dimension.
Create two expressions, one for the created date and another one with Decision
The created one should be Count(DISTINCT [Created date])
The decision date one should be similar.
Thanks, but it doesn't present the right data. Please see below. One pic with Distinct Count and the other with only Count.
The third pic shows the real data.
I am thinking the problem is the dimension? It should be a neutral date/calendar? That's not connected to Createddate or decisiondate?
Hi! I would suggest that you get your database in different shape so you can use month as dimension:
LOAD
*
INLINE [
Date,Type
2017-01-05,Decision
2017-02-06,Decision
2017-01-02,Created
2017-01-04,Created
2017-02-04,Created
2017-02-05,Created
]
Then in the bar chart use:
Dimension: Month(Date)
Dimension: Type
Measure: Count(Type)
let's try using the below script:
fact_table_created:
load
[created date],
[created date] as CalendarDate
from your_table where len(trim([created date])) > 0;
fact_table_decision:
load
[decision date],
[decision date] as CalendarDate
from your_table where len(trim([decision date])) > 0;
finally in your bar chart you can use MonthName(CalendarDate) as dimension.
Hi
I get an error,
i think you should replace "your_table" with your real table name.
and i guess you have to replace "from" with "Resident" if you already loaded it.
Embarrassing, of course. I will check it out when I can give it my full attention. I will get back to you.
Thanks
Can you share de qvf with this data?
Thanks!