Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have a dimension called 'Came From Code' and another dimension 'DTE' and a field called 'Orders'. Each Came From Code can have orders on different dates
I want to have a chart that shows the Quantity of 'Orders' for each 'Came From Code' over time (DTE)
I created the chart, with DTE as the dimension, orders as the expression and then have a drop-down for the came for codes
When I select a came from code, the chart does not show all of the dates on which there are orders.
Where am I going wrong
Just needed to:
IN DIMENSION TAB-
SELECT FIELD AND THEN CHECK ON SHOW ALL VALUES
IN PRESENTATION TAB-
SELECT FIELD AND THEN UNCHECK ON SUPRESS NULL VALUES
Dumb mistake
Can you share a sample file?
Came From Code | Date | Click-Throughs | EDP Visits | Orders | Tickets | Avg Conv | Total Value |
CFC_AM_PHP | 5/14/2018 | 4 | 1 | 0 | 0 | 0.00% | $0.00 |
CFC_BILLS_BBA | 11/16/2017 | 38 | 0 | 0 | 0 | 0.00% | $0.00 |
There would be multiple dates for each of the dimensions
What kind of chart are you trying to create or you have an issue with? Is it bar?
Your data looks okay.
Can you share your QVW with some sample data?
Cannot share the app at this time. Basically, for each came from code, there can be up to 365 dates. The idea of the chart is to first, make a selection from the drop-down to then see just that particular came from code over the dates
Many dates may have no value, which I think is causing only some of the dates to display?
Just needed to:
IN DIMENSION TAB-
SELECT FIELD AND THEN CHECK ON SHOW ALL VALUES
IN PRESENTATION TAB-
SELECT FIELD AND THEN UNCHECK ON SUPRESS NULL VALUES
Dumb mistake
Yeah if have 0 or null values the charts by default suppress them.
Also, as a suggestion create a master calendar to populate missing dates.